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

What is autocommit mode in sql server?

1076

explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1038

Explain the disadvantages of cursors?

1048

What is a non clustered primary key?

872

What is sql server profiler?

952

What are the advantages of using cte?

950

What are the different index configurations a table can have?

897

what is isolation level at dead lock?

2088

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

982

How to create new databases with "create database" statements?

958

What is default constraint?

931

Difference between DELETE and TRUNCATE?

1001

What is sql server english query?

1035

What is an example of a primary key?

911

What is the openxml statement in sql server?

1007