We have Change Manager.  It handles schemas but does not allow comparison of data.

Define the second server as a linked server on the first server. Linked servers can also be touchy about how the linkage has been configured. I use server...

Have you verified that the server "linkage" is actually working? After you create the link, can you select the linked server in EM, select the tables and see them?...

1. Read as much of SQL Server 2000 Books-on-Line (BOL) as you can. All the basics (and more) are covered and you will save yourself a great deal...

Thanks Andy,

I wasn't aware of xp_instance_regread. The BOL reference is very helpful as well.

Regards,

Justin

quote:

---

Generally, its transactions the system batches executed by a system process. The "." is representative of a system internal function. There is...

John,

Also a good idea. I started down that path yesterday, just executing sections of the code. Unfortunately I got sidelined with other issues. I'll go back to...

quote:

---

The sp is the code that checks for condition alerts to notify you about. You may have the box bogged down by...

The only alerts we have set up are tied to jobs that are run from a single administrative sql server and distributed to all the production servers. They...

The SQL Server Logs and Win2K Event Logs have no information regarding this error. It only shows up in the SQL Agent error log, with no additional information.