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

How do I get to sql server configuration manager?

959

---

What are group functions in query statements in ms sql server?

955

---

What is cross join in sql server joins?

1081

---

How do I find the transaction log size in sql server?

926

---

Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

1715

---

How to access the inserted record of an event?

998

---

What is a covering index?

939

---

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

845

---

How to delete duplicate rows in sql server?

1062

---

what is an index? : Sql server database administration

942

---

What is the use of @@spid?

965

---

What is 'write-ahead log' in sql server 2000 ?

999

---

What is difference between index and primary key?

1052

---

Explain about SQL server 2005?

929

---

Does partitioning ssd reduce performance?

857

---