Plus this book: "A Guide to SQL Server 2000 Transactional and Snapshot Replication" By Hilary Cotter

http://www.replicationanswers.com/Transactional.asp -- I like this one!

http://www.sqlservercentral.com/articles/Replication/2690/

http://www.informit.com/authors/bio.aspx?a=be0470b3-ab7f-4cc5-8f97-7c0ae88ff5de

http://www.code-magazine.com/Article.aspx?quickid=0311101

Andy Warren is the expert on Replication. Check his articles.

Than you John.

I figured out why. I right clicked on the missing database to attach. The missing database still shows up under the “databases” container but no plus...

Great stuff. It works on both SQL2005 and SQL2000.

Thank you Scott!

Need to clarify here. Should use third-party products (i.e. Idera's SQLSafe, Quest's Litespeed) to back up SQL2000 user database and restore to SQL2005 as part of the upgrade, or...

How about check table by table instead of checking the whole database in one batch?

Refer to Books online "DBCC SHOWCONTIG" example E, you may add your debug code to find...

Thank you all for your suggestions. I like the questions SQLBill listed, plus the idea about coffee/donuts. Storage people are not inaccessible as the storage itself. Anyway,...

May try "with fast" option, or schedule it while no much activities.

Here is an example of collecting fragmentation data via a scheduled job.

http://www.mssqltips.com/tip.asp?tip=1165

Hope this helps.

http://www.mssqltips.com/tip.asp?tip=1199

check this: http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx

The two can be combined together. Database can be mirrored from one cluster (SQL virtual Server) to another.

I like this post very much. Good discussions from the gurus. As the answer is Yes, the new question is “How to”. I would like to invite you...

check the message not the result set, or custmize your own report.

pwdcompare: takes two arguments - a varchar value that is a cleartext password and a varbin value that is a SQL Server password hash, and returns 1 if they match...

Is a DBA there? If not, anyone is a "DBA" then.