Ken Simmons, you are a genius. Sadly enough, I spent quite some time googling on this to no avail. Clearly I wasn't searching for the right thing..

Thanks again.

But if you rebuild your indexes after shrinking the data files, won't this force the data files to grow again during the rebuild essentially negating all of your work?

AHF,

I've gotten those as well in the recent weeks running the latest version of SQL 2000 and the only work around I found was to use the OPTION (MAXDOP 1)...

You guys are awesome. Great solutions given here and information I wil certainly put to use in the future.

In the meantime, I've decided to "trust" a little more and...

All great suggestions but I take it from these that there is no sure way to prevent someone with sysadmin privileges to change or even insert their own values in...

Great help and information Jay!

I suppose it's safe to say I may have found my "warm stand-by" database solution. The whole purpose of this exercise was to have a...

Jay,

I checked the identity values for the problematic tables and here's what I found:

For each table that had rows inserted into them by the replication, the current dentity value seemed...

basically, I want to have transactional replication set up and at a certain point in time, flip our applications to use the subscriber as the db. I got most...