Answer Posted / pavit

So many ways:
1.) right click on the server name and then click on
properties. From there you can see all the Server details
including sp.

2.) In Query Analyzer window type select @@version and
execute

3.) in Query Analyzer type xp_msver

4.) so so so so so so so

What is a database in ms sql server?

1057

---

What is the meaning of lock escalation and why/how to stop this? : sql server database administration

1037

---

How to handle error or exception in sql?

982

---

why would you use sql agent? : Sql server database administration

1210

---

What can be used instead of trigger?

1156

---

Explain indexing and what are the advantages of it?

1028

---

How do you delete a data source?

1007

---

Which data type columns are the best candidates for full-text indexing?

967

---

Why would you call update statistics?

1016

---

Is a primary key unique?

991

---

What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

957

---

When would you use the stored procedures or functions?

1000

---

What is the purpose of linked server configuration in sql server?

1048

---

Tell me what are the essential components of sql server service broker?

941

---

Define candidate key, alternate key, and composite key.

922

---