How do I check if a SQL Server 2005 installation has been Service Packed?

June 14, 2008 at 1:17 am Leave a comment

You can check whether a SQL Server 2005 installation has been service packed by running the following SQL code:

SELECT SERVERPROPERTY (‘productlevel’)

If SQL Server has been service packed, it will return with the Service Pack version installed, eg. “SP2”. If it has not been service packed, it will return with the result “RTM”.

Advertisements

Entry filed under: Uncategorized. Tags: , , , , , , , , , .

How do I create and use a Synonym for a table in SQL Server 2005? How do I execute the same SQL code multiple times?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Trackback this post  |  Subscribe to the comments via RSS Feed


Calendar

June 2008
M T W T F S S
    Jul »
 1
2345678
9101112131415
16171819202122
23242526272829
30  

Archives

Blog Stats

  • 32,563 hits

%d bloggers like this: