SELECT @@VERSION Running the above SELECT statemet will give you the ver

can you any body tell me which service pack is installed in
the sql server?

Question Posted / bharathi

Answer Posted / bharathi

SELECT @@VERSION

Running the above SELECT statemet will give you the version
of SQL server and its SP

Is This Answer Correct ?

5 Yes

0 No

Please Help Members By Posting Answers For Below Questions

System requirements for sql server 2005 express edition?

997

Does sql server 2000 clustering support load balancing?

950

What are the steps to process a single select statement?

924

How to modify the underlying query of an existing view?

972

You want to implement the one-to-one relationship while designing tables. How would you do it?

948

What are the steps you can take to avoid “deadlocks”?

961

What is the boxing and unboxing concept in .net?

902

Can we call future method from queueable?

1032

What are the database roles? : sql server security

1149

explain different types of backups avaialabe in sql server? : Sql server database administration

960

What is oltp (online transaction processing)?

984

Why use cursor in sql server?

1059

What is the difference between for auto and for nested?

986

What are the Advantages of using CTE in sql server?

1096

What is the Difference Between Primary and Foreign Key?

991