April 13, 2006 at 8:14 am
Is there any way of telling which hotfixes as well as SPs have been applied to a SQL Server?
As far as I am aware there is no way of finding this information via the database.
I know you can find the current patch level but would like to know what other hotfixes have been installed on the server.
Thanks in advance
Carl
April 13, 2006 at 8:51 am
SQL Server you can usually tell by the results of @@VERSION. Or are you speaking of the OS?
K. Brian Kelley
@kbriankelley
April 13, 2006 at 8:54 am
Hi Brian
I am aware that @@VERSION tells you the current patch level but it doesn't tell you what hotfixes have been installed, just what the current level is.
April 13, 2006 at 5:34 pm
Most tend to be cumulative... kind like how they deal with DNS. Closest thing to versioning:
About the only other thing you can do is find out what files were affected by a given hotfix and then check those files. Wouldn't be too hard to do, but I don't know anyone who has coded that up in a utility.
K. Brian Kelley
@kbriankelley
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply