I generally use "failure" to send emails. To get around the problem of email not working, and thus not getting the failure, I send myself a generic email every day...

We also use Diagnostic Manager and have been satisfied with it. They've had a few updates, which is good to see that they're keeping up to date. I nice feature...

Rudy ... Did you come up with a good solution ?    I'm in the same situation.  TIA

TDuffy ... I'm trying your approach and noticed you have a typo. If you...

I haven't seen that particular error before.  Are both servers on the same domain ? If so, is your SQLADMIN account a windows account or SQL account ?   I always...

I was missing /PAE ...  Thanks !

(I missed the joke)

Tim,

The little bit that I know is that the DTS migration tool will work for simple DTS packages, but some of the more complex ones will not convert because...

How big is your database ?  If it's fairly small, you can back up the database, which creates a .BAK file, put that on the CD, then put it on...

You also have to determine WHICH duplicate to get rid of. There's a difference between duplicate keys, and duplicate records. You may have duplicate customers: ABC Company entered twice, but...

How about

select top 1 eventtext, cutomerID

from CustomerDB

order by eventtimestamp desc

Why do you have so much fixing to do ?

I've never heard of Bridgehead.  We've used Idera's SQLSafe with good results. It compresses our 220 Gig backup down to 40 G, and runs in half the time as native...

This is what I do.  I backup DatabaseA on ServerA, Remote logon to ServerA, zip it, copy it to ServerB on the other domain

(copy D:\pgmFiles\MSSQL\Backup\DBA.BAK  \\RemoteServerB\d$\pgmfiles\MSSQL\BACKUP\ ),

unzip...

I actually like having all the backup history intact. I have found it useful as an analysis tool for backup run times and database growth because that info is stored...

Just to clarify .... Transactional replication requires a primary key, so that it can find the records to update. Snapshot replication does not require a key because it imports the...

Yes, locked tables from snapshot replication is a likely cause. Or running a snapshot for a re-initialized transaction subscription.  You can possibly adjust the timing of the various jobs involved. ...