How can i find what service pack i have for Sql 2005?

Asked By k.travolta 0 points N/A Posted on - 12/01/2011

Hi All,

How can i find what service pack i have for Sql 2005?

What's the easiest way and with select statement how can i find?

Thanks

• Status: Open
• Question Views: 883
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS SQL Server

Best Answer by Predator

Go To Solution

Best Answer

Best Answer

Answered By Predator 0 points N/A #85093

How can i find what service pack i have for Sql 2005?

Hi,

  It is not hard. To fine that which service pack we have installed in our machine we want to go help menu. In the help menu you want to click on about option.

A new information box will be open and that contained all version information of sql 2005.

Option window will be contained:-

1.       SQL server Management version

2.       2. Analytic service client tool version information

3.       Data Access Components Version information

4.       MSXML  version information

5.       .net Framework version information

6.       Internet explorer version information

7.       Operating System version information

And many more information you will see.

About Predator

Questions
2

Answers
54

Best Answers
27

• Vote Up 0 Vote Down

• Posted on - 12/01/2011
• Question Category: MS SQL Server

Answered By Meyers Marchan 5 points N/A #85094

How can i find what service pack i have for Sql 2005?

Hi,

I heard about SQL 2005 upgrade service pack I think you need administer rights to handle SQL first you must have an Intel i3 processor 2GB of ram 675 hard disk space.you can go to the Microsoft website you can find the SQL software download center www.microsoft.com.just make sure to complete the download time.

About Meyers Marchan

Questions
3

Answers
104

Best Answers
4

• Vote Up 0 Vote Down

• Posted on - 06/02/2013
• Question Category: MS SQL Server