Tuesday, January 6, 2015

How can Get SQL server version and SP information ?

Run below one of them:
1. xp_msver

 Go
2. Select @@VERSION 
Go
3.Select serverproperty('productlevel')

as 'productlevel',serverproperty('ProductVersion') as 'ProductVersion'
Go

No comments:

Post a Comment