C# Tutorials and offshore development in India

Prizes & Awards

My Profile

AdSense Revenue

Active Members
Today

Last 7 Days

more...

New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !

How to find which version of SQL Server 2005 is running?

Posted Date: 25 Oct 2007 Resource Type: Code Snippets Category: SQL Schema

Posted By: Tony John Member Level: Gold
Rating:

Points: 10

SQL Server does not display the service pack information in the Management Studio. This query shows how to identify which version of SQL Server is running and which service pack installed.

This approach will work for SQL Server 2005 and SQL Server 2006 to determine the version and servicepack installed:

								
SELECT  SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

The result will look something like below:


9.00.3054.00	SP2	Standard Edition

Responses

Author: http://venkattechnicalblog.blogspot.com/ 31 Oct 2007 Member Level: Diamond Points : 0

Hi Sir,

You can opt "select @@version" to achieve the same.

The result which i have got is "Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Developer Edition on Windows NT 6.0 (Build 6000: ) "

Regards,
Venkatesan Prabu. J

Feedbacks

Popular Tags

What are tags ?

Search Tags

(No tags found.)

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: Finding the first day and last day of the month using SQL
	Previous Resource: Dont allow to create Stored Procedure - Serious Work
	Return to Discussion Resource Index
	Post New Resource
	Category: SQL Schema

Post resources and earn money!

Related Resources

dotNet Slackers BizTalk Adaptors Web Design

doors in nj