How to determine the service pack currently installed on
SQL Server?
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 does recursive cte works in sql server?
Which sql server table is used to hold the stored procedure scripts?
Is it ok to shrink transaction log?
What is the contrast between sql and mysql?
What are the disadvantages of using querystrings to send data from one page to another?
How to replace given values with null using nullif()?
What are the new features in sql server 2016?
What are the advantages of using third-party tools?
What is the use of group by clause?
How to transfer an existing table from one schema to another schema in ms sql server?
Relational calculus is what type of language?
What do you understand by triggers?
What is the default sql server instance name?
Tell me the use of keyword with encryption. Create a store procedure with encryption?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration