Home arrow Technical Tips arrow Microsoft arrow SQL Server 2005 Service Pack, Version, Edition
SQL Server 2005 Service Pack, Version, Edition Print E-mail
There are ten ways to skin a cat, as we all know...funny, that we say it, but I don't anyone who has ever skinned a cat! Here is how I find out what SQL Server 2005 DB I am playing with: 1. Log into any DB in your SS 2005 instance 2. Run the following query: SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition') Enjoy!