How to determine the service pack currently installed on
SQL Server?
Answer Posted / rahul
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
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What are the different types of Indexes available in SQL Server?
How to verify a user name with sqlcmd tool?
Explain different backup plans?
What are the High-Availability solutions in SQL Server and differentiate them briefly?
How do I install sql server?
How you would rewrite the sql query to return the customerid sorted numerically?
What are distributed partitioned views?
What is the difference between char, varchar and nvarchar?
What is scan table/view and seek table/view when its occurs? : sql server database administration
How to download microsoft sql server 2005 express edition?
What do you mean by sql server 2005 express management tools?
Can group functions be used in the order by clause in ms sql server?
How to search for a string in all stored procedure in sql server?
How many types of stored procedures are there in sql server?
How can we delete Duplicate row in table?