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 list all stored procedures in the current database using ms sql server?
Can one drop a column from a table?
What is an identity?
What is indexing and its types?
What is normalization according to you and explain its different levels?
What is the cpu pressure?
How to delete duplicate rows?
Explain about SQLOS?
What is the security principal at the server level that represents your session?
Tell me what do you understand by a view? What does the with check option clause for a view do?
How to select true false based on column value in sql server?
How to use values from other tables in update statements in ms sql server?
How many clustered indexes there can be on table ?
Where are sql server user names and passwords stored in sql server?
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration