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
How to get @@error and @@rowcount at the same time?
What are the different acid properties?
How to backup SQL Server Reporting Services ?
What is replace and stuff function in sql server?
what is a join and explain different types of joins? : Sql server database administration
If a table does not have a unique index, can a cursor be opened on it?
What is not null constraint?
What is your recommendation for a query running very slow? : sql server database administration
Explain few examples of RDBMS?
what are the three command line utilities and what are their primary functions?
What are the system database in sql server 2008?
Explain the difference between primary keys and foreign keys?
What is subquery? Explain the properties of a subquery?
Introduction of rollup clause using sum and group by clause?
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration