How to determine the service pack currently installed on
SQL Server?
Answer Posted / pavit
So many ways:
1.) right click on the server name and then click on
properties. From there you can see all the Server details
including sp.
2.) In Query Analyzer window type select @@version and
execute
3.) in Query Analyzer type xp_msver
4.) so so so so so so so
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
What is a database in ms sql server?
What is the meaning of lock escalation and why/how to stop this? : sql server database administration
How to handle error or exception in sql?
why would you use sql agent? : Sql server database administration
What can be used instead of trigger?
Explain indexing and what are the advantages of it?
How do you delete a data source?
Which data type columns are the best candidates for full-text indexing?
Why would you call update statistics?
Is a primary key unique?
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
When would you use the stored procedures or functions?
What is the purpose of linked server configuration in sql server?
Tell me what are the essential components of sql server service broker?
Define candidate key, alternate key, and composite key.