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

Which language is supported by sql server?

0 Answers  

---

What does the on update no action do?

0 Answers  

---

syntex of insert

7 Answers  

---

How do I view views in sql server?

0 Answers  

---

Write a stored procedure for emplpoyee and department table to get DeptName which having no employee. Table Structure- Emp-Emp_Id,Emp_Name,Dept_id Dept-Dept_Id,Dept_Name

7 Answers   TCS,

---

---

How will u find the query which is running in some other machine

4 Answers   CarrizalSoft Technologies, IBM,

---

What are the 3 types of schema?

0 Answers  

---

what is denormalization? : Sql server database administration

0 Answers  

---

What are the types of sql server?

0 Answers  

---

What is replication with database mirroring? : sql server database administration

0 Answers  

---

Is resultset an interface?

0 Answers  

---

what is hash table

3 Answers   ILFS, Teledata,

---