Interested to Buy Any Domain ? << Click Here >> for more details...
How to determine the service pack currently installed on
SQL Server?
- 4 Answers
- 10474 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
Do you know what are the ways available in sql server to execute sql statements?
Define msdb database?
What is resultset concur_updatable?
Explain try...catch with sql server?
Do you know what is xpath?
How do you identify a foreign key?
Detail about query optimizer?
How efficient you are in oracle and SQL server?
What is tablesample?
How column data types are determined in a view?
Describe the functionalities that views support.
How to insert multiple rows with a subquery?
What are window functions in sql server?
What is the use of “join” in sql server?
How you can get a list of all the table constraints in a database?
