Answer Posted / kanan

how to catch the errors in sqlserver?

BEGIN TRY
SELECT 1/0
END TRY

BEGIN CATCH
RETURN ERROR_NUMBER()
RETURN ERROR_MESSAGE()
RETURN ERROR_LINE()
END CATCH

What is the size of transaction log file?

931

---

How optimize sql query with multiple joins in sql server?

900

---

What are the benefits of normalization?

1109

---

Is foreign key unique?

995

---

whats new about truncate in sql server 2008?

2502

---

What’s the distinction between dropping a info and taking a info offline?

1038

---

explain different types of constraints? : Sql server database administration

957

---

Explain nested join?

984

---

How to get @@error and @@rowcount at the same time?

1035

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

2344

---

What is snapshot report?

165

---

How to create new table with "create table" statements?

1109

---

How many levels of sp nesting are possible?

1024

---

How to encrypt Strored Procedure in SQL SERVER?

1167

---

How to write a query with a left outer join in ms sql server?

983

---