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 the basic functions for master, msdb, model, tempdb and resource databases?

0 Answers  

---

What are indexers?

0 Answers  

---

Data table as parameter in sql server?

0 Answers  

---

What does it mean to invest in the index?

0 Answers  

---

What are four major operators that can be used to combine conditions on a where clause?

0 Answers  

---

What do you understand by hotfixes and patches in sql server?

0 Answers  

---

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

0 Answers  

---

After removing a table from database, what other related objects have to be dropped explicitly?

0 Answers  

---

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

0 Answers   MCN Solutions,

---

How to restore performance issues and how to check?

0 Answers  

---

as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration

0 Answers  

---

What are rows and columns?

0 Answers  

---