How to determine the service pack currently installed on
SQL Server?
- 4 Answers
- 9623 Views
- HCL, I also Faced
- E-Mail Answers
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 have included columns when we talk about sql server indexing?
What do we need queues in sql service broker?
Tell me what is the order in which the sql query is executed?
How to get a list of columns in a view using the "sp_columns" stored procedure?
What is rtm version in sql server?
What is the difference between mysql and mysqli?
How many types of keys are there?
How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?
How do database indexes work?
What is data source object?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
What are date and time data types in ms sql server?
How to find the login name linked to a given user name?
What is an indexing technique?
Explain how you can configure a running aggregate in SSRS?
