As most of my posts are inspired by stuff I’ve been working on or have worked on recently this is no different. A request came in to upgrade a SQL Server 2005 Standard Edition Instance to a SQL Server 2005 Enterprise Edition Instance. Funny thing is that I’ve been working with SQL Server 2005 since [...]
Posts Tagged ‘Edition’
Quick Script for Server, Version, Level, and Edition
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 [...]
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 [...]
