How to determine the service pack currently installed on
SQL Server?
- 4 Answers
- 9622 Views
- HCL, I also Faced
- E-Mail Answers
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
How to check table values in sql server?
Explain what are partitioned views and distributed partitioned views?
What is a join in sql?
What are commonly used mssql functions in php?
What is rs.exe utility?
How many clustered indexes there can be on table ?
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
Do you know what is sql service broker?
What is sql profiler. What are the default templates with it? : sql server database administration
how to avoid cursors? : Sql server database administration
How does index makes search faster?
What is difference between order by and group by?
What are 3 ways to get a count of the number of records in a table?
What are different types of collation sensitivity?
What does sql server mean?
