The global variable @@Version stores the build number of the sqlservr.exe

How to determine the service pack currently installed on
SQL Server?

Question Posted / swapna

Answer Posted / swapna

The global variable @@Version stores the build number of
the sqlservr.exe, which is used to determine the service
pack installed.

Is This Answer Correct ?

9 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to get @@error and @@rowcount at the same time?

1035

What are the different acid properties?

1068

How to backup SQL Server Reporting Services ?

149

What is replace and stuff function in sql server?

1067

what is a join and explain different types of joins? : Sql server database administration

960

If a table does not have a unique index, can a cursor be opened on it?

915

What is not null constraint?

1127

What is your recommendation for a query running very slow? : sql server database administration

1047

Explain few examples of RDBMS?

1041

what are the three command line utilities and what are their primary functions?

145

What are the system database in sql server 2008?

1035

Explain the difference between primary keys and foreign keys?

1025

What is subquery? Explain the properties of a subquery?

988

Introduction of rollup clause using sum and group by clause?

968

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

910