N/APosted on - 11/30/2011
How can we track the date and time of the last patch installed on my SQL Server so that I can be able to track whether the installed patch is an update or a hotfix?
Track Date and Time of Patch in SQL Server
So you have chose to safe the SQL Server structure as well as you will not understand exactly in which to begin. This primary manual inside a two-part series on SQL Waiter spot reading may help an individual track down these pesky waiters prior to obtaining these people effectively repaired.
SQL Waiters represent a substantial certificate problem for a quantity of causes. Primarily, they may be ubiquitous. A huge selection of computer application packages utilizes SQL Server being an info retailer as do numerous commercial websites. Additionally, since SQL Server 2000 may have multiple situations up about an individual device which must each become spotted separately, developers typically possess a minimum of 1 instance regarding their particular neighborhood figures or sample apps.
SQL Waiter provides functions not rolled into Microsoft's Home house glass Microsoft windows 7 Update or perhaps Windows Update Employment Equipment and therefore the particular players unusually get the repair attention these people merit. And finally, SQL Players typically work having a quite high amount of privilege (Local System) although SQL Waiter 2000 defaults to the appellation of the sphere user account.
A lot of people work SQL Server being a Local System consideration, there are number of causes: They in no way took time to inquire their head for any sphere user explain SQL Server; they will not