Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tran008
Starting Member
38 Posts |
 Posted - 2004-06-04 : 17:16:01
|
| Hi all,I have the following in the error log, and wonder if anyone come accross these.thanksUsing 'xpsqlbot.dll' version '2000.80.194' to execute extended stored procedure 'xp_qv'.Using 'xpstar.dll' version '2000.80.194' to execute extended stored procedure 'xp_sqlagent_monitor'.Configuration option 'allow updates' changed from 0 to 1. Run the RECONFIGURE statement to install.Error: 15457, Severity: 0, State: 1Configuration option 'allow updates' changed from 1 to 0. Run the RECONFIGURE statement to install..Error: 15457, Severity: 0, State: 1 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-04 : 17:21:52
|
| "SQL Server Agent starts the xp_sqlagent_monitor extended stored procedure (SQL Server Agent Monitor) to monitor the SQLServerAgent service to ensure that it is available to execute scheduled jobs, raise alerts, and notify operators. If the SQLServerAgent service terminates unexpectedly, the SQL Server Agent Monitor restarts the service."The extended stored procedure is probably the one changing the option of allowing updates to the system tables. You'll also see those lines when you install a SQL service pack, well at least the lines about sp_configure. IOW, don't be concerned about these lines in the Error Log as they are expected. These are just informational.Tara |
 |
|
|
|
|
|
error log