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

How to generate create view script on an existing view?

944

---

How can we check the sql server version?

979

---

What do you understand by triggers?

854

---

How do I get Report Builder to generate a parameter that can be set by users viewing the report?

139

---

What is system stored procedures?

975

---

What is index in an assignment?

887

---

What are translations and its use? : sql server analysis services, ssas

992

---

How to delete multiple rows with one delete statement in ms sql server?

942

---

What are click through reports?

138

---

What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

947

---

What are horizontal and vertical scaling?

170

---

Introduction of rollup clause using sum and group by clause?

898

---

What is extended stored procedures?

900

---

What is bcnf normalization form?

1064

---

Which tcp/ip port does sql server run on? How can it be changed?

975

---