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 the use of @@spid?

1051

Can you insert NULL in unique column?

1213

What is the difference between truncate and delete commands?

1110

Explain the phases a transaction has to undergo?

1115

What is sub-query in sql server? Explain its properties.

1134

IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

1874

In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

2077

Explain what is public role in sql server?

1193

What the different types of Replication and why are they used?

1133

What is the maximum size of column in sql server?

946

Which database stores information about replication?

1128

Explain the rules for designing files and file groups in sql server?

1022

What are secondary xml indexes?

1077

Tell me what do you mean by an execution plan? Why is it used? How would you view it?

949

What are the restrictions that views have to follow?

1032