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

Can two tables have the same primary key?

0 Answers  

---

can i write function in stored procedure and stored procedure in function and nested procedure.Give one example for each question?

1 Answers   Cap Gemini, TCS,

---

How can you start sql server in different modes?

0 Answers  

---

What is the meaning of sql server?

0 Answers  

---

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

0 Answers  

---

---

What is sleeping status in sql server?

0 Answers  

---

1. SELECT SUM(sal) as “Gross Salary” from EMPLOYEES; 2. SELECT MAX(sal) as “Highest Salary” from EMPLOYEES; ouput should be in table format

2 Answers  

---

What are database states in ms sql server?

0 Answers  

---

If the job running very slow what is the action you do

0 Answers  

---

how you can move data or databases between servers and databases in sql server? : Sql server administration

0 Answers  

---

How many types of subqueries are there in sql server?

0 Answers  

---

How we Resize table,temp table, database and log file size in SQL Server 2005

1 Answers   ABC,

---