How to determine the service pack currently installed on
SQL Server?
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
What is the fillfactor concept in indexes?
What are the steps to follow to configure SQL*Net?
Define master database?
How can we migrate from SQL server to SQL Azure?
What is SQL Azure?
What is correlated subquery in sql server?
What is an expensive query?
Can a table be created inside a trigger?
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
How do I find the default sql server instance?
What is the library index called?
What is difference between clustered index and non clustered index?
Difference between Logical Page and Physical Page in SSRS.
What is primary key index?
What is efficiency data?