SQL DBA-ASR
Monday, August 22, 2011
These are the Commands for finding the version of the SQL Server
EXEC sp_server_info
xp_msver
select serverproperty('ProductVersion')
select @@version
1 comment:
A.S. Reddy
October 19, 2011 at 2:34 PM
for service pack
select serverproperty('productlevel')
Reply
Delete
Replies
Reply
Add comment
Load more...
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
for service pack
ReplyDeleteselect serverproperty('productlevel')