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 update locks?

514

---

do views contain data ?

590

---

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

619

---

What is forward - only cursors / read only cursor?

523

---

How to change the data type of an existing column with "alter table" statements in ms sql server?

531

---

---

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

527

---

According to you what goes into making the best database administrator? : sql server database administration

551

---

What is indexed view?

601

---

List down some advantages of sql stored procedure?

564

---

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

730

---

Which are the third-party tools used in sql server and why would you use them?

494

---

How to connect sql server management studio express to sql server 2005 express?

586

---

What is the difference between Stored Procedures and triggers?

576

---

What are Row versions of DataRow?

608

---

How to maintain a fill factor in existing indexes?

533

---