Answer Posted / indraneelandhavarapu

With SQL Server 2005, new error handling has been introduced
with the TRY...CATCH processing. Basically what happens is
when an error occurs the processing in the TRY block stops
and processing is then picked up in the CATCH block.

ERROR_NUMBER() Returns the number of the error
ERROR_SEVERITY() Returns the severity
ERROR_STATE() Returns the error state number
ERROR_PROCEDURE() Returns the name of the stored procedure
or trigger where the error occurred
ERROR_LINE() Returns the line number inside the routine
that caused the error
ERROR_MESSAGE() Returns the complete text of the error
message. The text includes the values supplied for any
substitutable parameters, such as lengths, object names, or
times

When I run the sql server 2000 setup, it just hangs. What do I do?

1129

---

What is store procedure? How do they work? When do you use?

1000

---

How to delete all rows with truncate table statement in ms sql server?

1047

---

Does any body please help me what question's have asked for SSRS in the interview?

2204

---

explain different types of cursors? : Sql server database administration

1148

---

What are the essential components of sql server service broker?

1067

---

Can I run multiple instances of sql server 2000 at the same time on one computer?

1122

---

How to disable stored procedure sql server?

1671

---

How to link tables in sql server?

976

---

What is the maximum row of a size?

1070

---

How to get a list of all tables with "sys.tables" view in ms sql server?

1085

---

What is indexed view? How to create it?

1071

---

Write a sql query to delete duplicate records from a table called table1

1088

---

Explain full-text indexing?

1045

---

What is compression - row-level and page-level compression?

965

---