Browse by Tags
All Tags »
SQL Agent (RSS)
Sorry, but there are no more tags available to filter with.
First part of this post is available at SQL Server Agent failing to start because "The EventLog service has not been started" . I've just confirmed an improvement has been already checked-in into SQL Server 2008's code which keeps up calling
Read More...
( This post has been extended with SQL Server Agent failing to start because "The EventLog service has not been started" (Second Part) ) One customer reported to us that their SQL Server 2000's SQL Server Agent services, recently started to
Read More...
The following topic in SQL Server 2000's documentation “Backing Up the model, msdb, and distribution Databases” ( http://msdn2.microsoft.com/en-us/library/aa173541(SQL.80).aspx) , and the equivalent in SQL Server 2008 “Backing Up the model and msdb Databases”
Read More...
Another troubleshooting story to share... Customer was using SQL Server 2000 (build 8.00.2162). They use SQL Agent mail for sending notifications about job completion. They upgraded their Exchange Server 5.5 to Exchange Server 2003, and since then
Read More...
KB Article 943525 (You cannot start the SQL Server Agent service of a failover cluster of SQL Server 2005 if the build of SQL Server build is 3179 or a later build), in its first revision (November 21, 2007), it enumerated three different workarounds,
Read More...
One customer reported that when he was executing the following batch use master exec sp_updatestats from SQL Server Management Studio (SSMS) he was getting different results than when the same stored procedure was ran from a SQL Server Agent's Job. Specifically
Read More...
