Answer Posted / neetu

In SQLSERVER 2005 exceptions are handle by using RaisError
with Try catch like in other prog languages.
Begin Try

End try

Begin Catch

End Catch
BEGIN TRY

RAISERROR ('Yaa, I ma the problem', 16,1)

END TRY



BEGIN CATCH

SELECT ERROR_NUMBER() as ERROR_NUMBER,

ERROR_SEVERITY() as ERROR_SEVERITY,

ERROR_STATE() as ERROR_STATE,

ERROR_MESSAGE() as ERROR_MESSAGE

END CATCH



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.

Explain about remote stored procedure?

1006

---

If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

1099

---

How to generate create function script on an existing function?

1109

---

difference between Clustered index and non clustered index ?

989

---

What is difference between clustered and non clustered index?

981

---

Can foreign key be deleted?

918

---

You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

1004

---

What is a data source file?

969

---

What is indexing explain it with an example?

1004

---

What are the system database in sql server 2005?

1040

---

How to create sub reports?

242

---

How to filter records of table in SQL SERVER?

1081

---

What are window functions in sql server?

1002

---

can a database be shrunk with users active? : Sql server administration

1002

---

Does a full backup include transaction log?

962

---