When managing a large SQL Server environment you probably have different versions, levels, and editions of SQL Server running throughout. A nice quick way to extract this information is to use the script below: SELECT @@SERVERNAME AS ‘ServerName’, SERVERPROPERTY(‘productversion’) AS ‘Version’, SERVERPROPERTY (‘productlevel’) AS ‘VersionLevel’, SERVERPROPERTY (‘edition’) AS ‘Edition’ This works for SQL 2000, SQL 2005, and [...]
Posts Tagged ‘Version’
SQL Versions, Editions, and Features
When putting forth a recommendation for a version and edition of SQL Server to install it is important that you understand what features are available in each version and edition. SQL 2000 – http://msdn.microsoft.com/en-us/library/aa175266.aspx SQL 2005 – http://msdn.microsoft.com/en-us/library/ms143761(SQL.90).aspx SQL 2008 – http://msdn.microsoft.com/en-us/library/cc645993.aspx These 3 websites give you a very detailed look into each version and [...]
