How to determine the service pack currently installed on
SQL Server?
- 4 Answers
- 9620 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
can any body tell me how to know the password of current user in sql server
Can a table be created inside a trigger?
What are the diifferences between the ms sql server vs mysql?
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
What are the hotfixes and patches in sql server?
What is tempdb in sql server?
What are parameterized reports?
What is the purpose of grouping data in a report?
If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Please explain what is “asynchronous” communication in sql server service broker?
What is the maximum number of index per table?
Explain few of the new features of sql server 2008 management studio
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
how will add additional conditions in sql?
