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 is trigger and different types of Triggers?

0 Answers   QuestPond,

---

Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?

1 Answers  

---

Can you type more than one query in the query editor screen at the same time?

0 Answers  

---

Can we use Truncate command on a table which is referenced by FOREIGN KEY?

2 Answers   Shriram,

---

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

0 Answers  

---

---

How to replace the Query Result 'Null Value' with a text ?

0 Answers   MCN Solutions,

---

How to change server name in sql server?

0 Answers  

---

What is the main difference between ‘between’ and ‘in’ condition operators?

0 Answers  

---

Differentiate between truncate vs delete in mssql?

0 Answers  

---

in my server i have 3 instances,one of them got failed, and this cause we r not able to connect to server, how to know which instance was dameged?

1 Answers   IBM,

---

What is a Trace frag?Where can we use this?

1 Answers  

---

Explain table valued parameters in sql server? Why tvp used?

0 Answers  

---