Thank you so much!!!

Going to try that today.

Thank you for the replies. Everything I have found on this says that this was fixed in 2008, however, we are having the problem, so apparently, it is still...

We have found that have zipGenius installed on the server and using Hyperbac to do the SQL backups causing this issue as well. Once zipGenius was removed the problem...

Another option is to DTS the table out, then drop and readd the column through replication properties or sp_repldropcolumn, sp_repladdcolumn (see BOL), then update the records setting the replaced column. ...

Do you not have shared storage between the two servers?

We just migrated.  If the DNS entry was changed, then this will cause a lot of connectivity issues, including getting connected, but then timing out.  What we found is that...

Have you checked the maint plan history to see where the failure occured and what may have been successful? I have found that it is very helpful on telling...

Are you running Clustering Services on the server?  If the MSDTC is not installed properly when installing SQL as a clustered instance, then distributed transactions will not work.  http://www.microsoft.com/sql...

I keep an admin database on each server with all of the procs that we use. However, due to some of the procs using sysobjects of the master database,...

I have seen the rollback error and we have had to restart SQL as well. But on the xp_sendmail issue, we were having some severe problems with it hanging...

I have 5 locations with the same build, Win 2K Advanced Server, SQL 2K, sp2, MDAC is 2.62, clustered on 2 nodes. I don't have .NET or anything else...