How to determine the service pack currently installed on
SQL Server?
- 4 Answers
- 8909 Views
- HCL, I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
How to assign new column names in a view?
what are isolation levels? : Sql server database administration
Explain what is the difference between union and union all?
What is the default schema of your login session in ms sql server?
Explain about temporary stored procedure?
Would you store your query in a ssrs report or a database server? State the reason why?
Explain powershell included in sql server 2008?
How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?
What is a transactions?
What is simple indexing method?
Which tools are available to manage SQL Azure databases and servers?
what is package and it uses and how can u call a package
What is sql service broker?
What do you understand by user-defined function in the sql server?
What do you understand by mirroring?
