How to determine the service pack currently installed on
SQL Server?
Answers were Sorted based on User's Feedback
Answer / swapna
The global variable @@Version stores the build number of
the sqlservr.exe, which is used to determine the service
pack installed.
| Is This Answer Correct ? | 9 Yes | 1 No |
Answer / 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 |
Answer / 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 |
What are commonly used mssql functions in php?
What is normalization? Describe its different types.
How To Find That One Week Change in My DataBase we Have Done Like We Have A database Test I Change Table,Stored Procd. Then I Find Which SP,Table We Have Edit/Change in Seven Dayes
Where is my database stored on the hard disk in ms sql server?
Difference between group by clause and having clause in SQL?
Detail about query optimizer?
How to write query to Delete the records in child table and corresponding records in parent table
What sql server means?
What protocol does sql server use?
how to find 6th highest salary
What is the use of floor function in sql server?
Explain Normalization and DE normalization
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)