Service Pack information

Question

Service Pack information

ravisamigo

SSCertifiable

Points: 7440
More actions
December 8, 2010 at 1:59 am

#143757

Dear All,
How to check when service pack was applied on SQLServer2005?( Service pack wise)
Thanks and Regards,
Ravichandra.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Feeg SSCrazy Points: 2766 More actions · Answer 1

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

MCITP: Database Administrator 2005
MCTS SQL Server 2008
MCP SQL 2012/2014
MCSA SQL Server 2012/2014
MCSE Data Management and Analytics

ravisamigo SSCertifiable Points: 7440 More actions · Answer 2

Thanks for the reply.

But, I couldn't see any answer please.

Regards,

Ravichandra.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

I don't believe there's any record within sQL as to when the patches are applied, just which one the system is running on.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

curious_sqldba SSC-Dedicated Points: 36494 More actions · Answer 4

try this http://www.sqlservercentral.com/articles/Administration/2960/..might be helpfull

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 5

I think you can find the date and time from the summary file in

C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG

Thank You,

Best Regards,

SQLBuddy

MG-148046 SSCrazy Eights Points: 9946 More actions · Answer 6

Control Panel --> Add Remove Programs should have the date the SP was installed.

MG

"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare

"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.