Sp or Hot Fix Install Date 1

[ptheriault]

Is there a way to find out the date a SP or Hot fix was installed on?

 

[Catadmin]

Not that I'm aware of. Unless there's a record for it in Add/Remove Programs.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[ptheriault]

I wish they would add that information. It would be nice to know.

 

[Catadmin]

What version of SQL are you running? I'll double-check some tables and see if anything comes close.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[ptheriault]

It's SQL 2000. someone installed HotFix 977 without my knowledge and I'm trying to find out when.

 

[Catadmin]

Hang about. Have you tried SELECT @@VERSION yet?

Also, look in the Event View -> Application Log on the server. Installs are usually logged there.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[ptheriault]

I did @@version but it didn't offer me the date I was looking for. I just found it in add/remove programs. Thanks for the help.

 

[Catadmin]

Glad I could help. @=)





Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"