It is not unusual to have several subscriptions to one publication, even with mixing 2000 with 2005 versions of SQL Server. My setup currently has a number of subscribers on...

I very much enjoyed reading this article - it flows well and the comments are very relevant to the community you are writing to.

I would just like to add...

Dave, I think this is wishful thinking. There are many tools out there that can deal with database schema differences, but not to script out the changes as replication DML...

To answer your particular question, for a 4GB production server, you are limited to using the /3GB switch. The /PAE switch is only applicable to OSs having more than 4GB...

"This means a SQL 2000 instance with AWE enabled will leave only 128MB for the OS."

I always set the maximum memory to allow for the OS to have at least...

OK, we'll need to look a bit deeper into how SQL Server works. As you know, SQL Server stores data in 'pages' that is sized at 8KB - this is the reason why...

This is how differential backups work - by definition, it will store all changes since the last full backup, so that for a daily diff backup you should see an...

I am not sure that you should be tinkering with the distribution database, apart for maintenance purposes. Since you have a nightly process to load the data into the publisher...

There is some discussion of this in this article (http://www.sqlservercentral.com/columnists/abressi/2634.asp) published today. It should help you to get started.

I think you will need this book "The Data Warehouse ETL Toolkit" co-authored by Ralph Kimball. You can purchase it from Amazon.

Thanks for posting the results of your investigation Tim. At least something was 'fixed'!

Since you mentioned that the issue arose out of nowhere, the only thing that could have caused...

To get a 'feel' for these counters (and any other counters for that matter), you will need to establish a performance baseline. What this means is that you should gather...

It looks more like installation of service packs or other applications that might be causing the problem. A recent post in a microsoft forum describe a similar problem, but its...

You are quite right Colin, and the referenced article does describe the alternative that you've mentioned.

The approach that has worked for me is to use the approach I've outlined above...

I was more interested in how you managed to remove the File Enumerator from the enumeration list!

Not sure if this will work, but try closing all running applications, and copy...