It generally is because you're holding up a database operation while the email is being readied and sent. What's typically done is a trigger would dump to a table which...

SELECT * FROM (TableName) WHERE birthdate IS NULL

USE DatabaseA

GO

EXEC sp_changedbowner 'sa'

GO

Stardate, anyone?

I know you've re-attached as sa, but check the ownership of all three database again by using sp_helpdb '<database>'

If any of them aren't owned by sa, switch to that database...

I'm assuming you've tested it as a vbscript script on the server to see if you are getting the same error. The only thing I can think of is an...

In the future, sp_changedbowner can set the database owner without you having to detach/attach. Did you set the cross db ownership chaining on all the databases before or after the...

Can you restore the backup to another database server with enough space, shrink down the log file, take a backup and then restore it?

What is the error message?

It sounds like what you're trying to do can be more easily accomplished by using traces. Is there a reason you are avoiding those?

check your sqlsp.log to see if there was an error along the way. This should be in C:\Windows. You'll find the sp_dboption stored procedure in the sp3_serv_uni.sql sql script, which...

If cross database ownership chaining is on (as ALZDBA has pointed out is needed unless you define specific permissions), do the users have access to both databases? Also, are the...

I did work on it in SQL Server 2000 after observing how Microsoft attacked the problem for a particular contest. Here is the write-up I did:

http://www.sans.org/reading_room/whitepapers/application/1273.php?portal=33dd61d594ec6f9ca63acf24a29bc898

I don't think anything...

There's a virtual lab available from Microsoft that covers this situation. I believe it's free, you just have to put up with a follow-up call from Microsoft. The lab should...

When you registered the SQL Servers, I'm assuming you did so with Windows authentication. Did your Windows rights change on the servers themselves? If you aren't a member of the...