I always use a Windows account. And when I run replication between 2 different Windows domains, I use a Windows account that is exactly the same on both servers.

Do your...

I don't remember if it was only for the affected table. Run a test scenario, and look in the history of the subscriber job and it will show you which...

I did this with good results when I needed to change the length of a field in a replicated table. -- Specifically: Drop a table from...

We had a situation where the network admin accidentally un-installed SQL on the publishing server. We had no current backup of the distribution database, so all the transactions pending to...

I've got 5 2000 publishers going to 5 2005 subscribers. I'm having trouble with 1 of the subscribers balancing the record counts to what i think they should be, and...

We're going to upgrade our production box from Standard to Enterprise as well.  If anyone has any suggestions or "gotchas" to pass along, that would be much appreciated.

I came across a reference to InstCat elsewhere, but wasn't sure about it.  I'm looking at it now, and it runs about a million commands !!  A little scary looking

I looked deeper and saw that despite the success, it said the snapshot was not yet available. 

"The initial snapshot for publication 'Prd - MktgDB_CIR' is not yet available."

There's also this...

You could run a "DIFF" between the databases, to identify difference between each table in your Publication Database and Subscription Database and output the results to a work table. Then perhaps...

We use idera's SQLSafe for our big production backup. It's gone from 1 hour down to 25 minutes, and the backup file from 220 Gig to 40 Gig.

I don't think you can. You'll get an error that the file is in use. You would have to detach, backup, then reattach, but that takes the DB out of...

I assume you restored to a different DB name so as not to affect the other data in your live DB ?

You can't backup the database and tlogs at the same time. Your T-log backup will fail.  It's pointless to try anyway, because your full backup is backing up everything.  Run...

I did this with good results when I needed to change the length of a field in a replicated table. -- Specifically: Drop a table from...

There's also the syssubscriptions table in the publication database that references the subscription database name.  Trying to change things this way sounds frought with problems. i think you'd be better...