I always use a Windows domain account with SQL Admin rights for replication, not a SQL account.  If you use a SQL account, you may have to make sure the name...

I agree. This is not a job for replication.  The maintenance of replication will be a nightmare if you are making database schema changes on your source server (publisher).

I'm trying to come up with a secure way to write down my passwords to avoid these emergencies. Something along the lines of saving a list of just passwords somewhere,...

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...