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

What is the difference between push and pull subscription? : sql server replication

1150

---

What is subquery explain with example?

1009

---

What is service broker? : sql server database administration

942

---

How to write character string constants or literals in ms sql server?

960

---

if no size is defined while creating the database, what size will the database have? : Sql server administration

935

---

how would you troubleshoot blocking? : Sql server database administration

945

---

Why would you call update statistics?

961

---

How many types of objects are there?

937

---

How to define the name and server for a new dsn?

1009

---

Explain foreign key in sql server?

978

---

Write a program using SQL queries to find a unique entry in a table.

943

---

Why truncate is ddl?

1030

---

What is set nocount on?

895

---

What are the 7 disadvantages to a manual system?

909

---

What are the requirements to use odbc connections in php scripts?

1061

---