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
What is pivot and unpivot?
What is row_number()?
what is package and it uses and how can u call a package
Can we perform backup restore operation on tempdb? : sql server database administration
What is 4nf in normalization form?
What is subreport?
What is data source document?
Tell about MOM Tool(Microsoft Operator Manager)?
Detail about the hardware which is supported by SQL server?
Can we use where clause in union?
What are the mathematical functions supported by sql server 2005?
What languages bi uses to achieve the goal?
List some major differences between triggers and stored procedures?
Where in ms sql server is ’100’ equal to ‘0’?
What is the purpose of data source?