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
Benefits of Stored Procedures?
What is a system database and what is a user database?
What is extended stored procedures?
What is a data source file?
What is change data capture (cdc) feature?
How do I schedule a sql server profiler trace?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
Define primary key?
What are the requirements on sql server network connections?
How to provide login information for a new odbc dsn?
Can sql server 2016 run on windows 7?
How to drop existing views from a database in ms sql server?
Can you explain what is the use of custom fields in report?
What happens on checkpoint?
What are the characteristics of modern DBMS?