Answer / ramesh.l.v

SELECT SERVERPROPERTY('PRODUCTLEVEL')

Answer / swapna

The global variable @@Version stores the build number of
the sqlservr.exe, which is used to determine the service
pack installed.

Answer / rahul

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

Answer / 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 are views in ms sql server?

0 Answers  

---

What is user-defined scalar function?

0 Answers  

---

Can some one please help with a query which will take only max value of a column in a join.

2 Answers  

---

Is there any difference between the primary key and unique key?

0 Answers  

---

What are the approximate numeric data types?

0 Answers  

---

---

What is index, cluster index and nonclustered index?

0 Answers  

---

what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

0 Answers  

---

how to copy sysdatabase file from c: Drive to D: Drive in SQL Server.

6 Answers   IBM,

---

How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

0 Answers  

---

What is field with example?

0 Answers  

---

Delete duplicate records from the table?(Table must have unique id)

7 Answers   TCS, Thomson Reuters,

---

What is excution Plan in sql server

1 Answers   CarrizalSoft Technologies, TCS,

---