Find SQL server and OS Version information for current instance

[sourcecode language=”sql”]

SELECT @@VERSION AS [SQL Server and OS Version Info];

or

SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’)

[/sourcecode]

– This T-SQL command will help to determine the version of SQL server you are running and corresponding Windows Operating System version

 
comments powered by Disqus