What is my SQL Server Version, Service Pack, Edition
Requirement: Wanted to check the installed SQL Server version service pack level.
SELECT @@version ? It didn't give me the Service pack information.
Query to Check SQL Server version, Service pack and Edition:
KB Article: http://support.microsoft.com/kb/321185
SELECT @@version ? It didn't give me the Service pack information.
Query to Check SQL Server version, Service pack and Edition:
SELECT SERVERPROPERTY('productversion') [Product Version], SERVERPROPERTY ('productlevel') [Service Pack], SERVERPROPERTY ('edition') [Edition]
KB Article: http://support.microsoft.com/kb/321185
Can we use Powershell?
ReplyDeleteLocal vs Remote SQL Properties!!