SQL Server 2005 Service Pack, Version, Edition

By M&S Consulting (Ashok) on May 2nd, 2007
Filed Under Technical Tips // Tags:

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')
Bookmark and Share

Related Information:

  1. SQL Server 2005 Install Samples
    If you have installed SQL Server 2005, it is likely you have installed the samples as well. In my case,...
  2. SQL Server 2005 Licensing Costs and Pricing Example
     Processor Licensing Model. Under this model, a license is required for each physical or virtual processor accessed by an...
  3. Oracle Application Server Startup and Shutdown Script Generator - FREE
    Complete the below to receive scripts to automatically startup and shutdown your Oracle Application Server 10.1.2.x or 10.1.3.x midtier environment....
  4. Oracle IdM - SAML SSO with Google Apps
    We recently integrated Oracle IdM with the SAML SSO Service from Google Apps. Now customers can continue to authenticate against...
  5. Google Apps Reporting API - Not quite this easy with Exchange
    I have been somewhat enamored by Google Apps and its potential. Many enterprises have been happy with Exchange for mail,...
  6. Google Custom Search Engine (CSE)
    The site search game is changing with Google CSE....

Leave a Reply


Archives

Recent Comments

  • Kavitha Muniraj said: Hi, Could you please send a script which checks the status of forms and reports of oracle...
  • Siddharth said: Hey thanks a lot !! Have been lookin all over for this :) My PC may not be able t handle FlashBuilder...
  • Cyrex said: Hey man why I cant install Apex 4? is there anyone can help me.,?
  • sharanabasava said: ALTER TABLE [my_table_name] RENAME COLUMN [current_column_name] TO [new_column_name]; Sir,I...
  • Huub Vankan said: Thanks for this easy solution. Indeed strange that is does not work in the (x86) folder….

Calendar

July 2010
M T W T F S S
« Jun    
 1234
567891011
12131415161718
19202122232425
262728293031  

Featured Testimonial

"M&S has taken 'partnership' to a new level. They are not only a deeply skilled service provider, the M&S team is actually a mission critical component to our operations, taking on new initiatives as well as maintaining custom, open source, and COTS solutions."

CEO, MedPivot

Free SQL Service