SQL Server 2005 Service Pack, Version, Edition

Posted on May 2, 2007 in Technical Tips | 0 comments

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')

Related Information:

1. SQL Server 2005 Licensing Costs and Pricing Example

   Processor Licensing Model. Under this...

2. SQL Server 2005 Install Samples

   If you have installed SQL...

3. SharePoint Editions – Version Naming: WSS, Services, Foundation, Server, MOSS, 2003, 2007, 2010

   I talk to many customers...

4. Installing APEX 4 on Windows Server 2003 64 bit edition with Oracle Database 11g

   Overview This tutorial article and...

5. Oracle Express Edition (XE) 10g Windows Download

   The following are links to...

6. Oracle XE Limitations (CPU, RAM, Data Limits)

   I was trying to make...

7. Oracle Application Server Version – Verify 10g Upgrade to OracleAS 10.2.3 for Portal 10.1.4.2

   There are a couple of...

8. ktpass Version – Which version do I have?

   If you have run into...