What is the size of your database before and after you run the SELECT...INSERT. If either the database or the tran log grows during this process, you will have...

If you do use a backup agent do make your backups, make sure you test the restore process!

Any plans for making backups need to start with your recovery SLAs. ...

It is probably worth talking to your DB2 DBAs. They should have more experience of client connectivity to DB2 than a pure SQL Server DBA.

You may also want to...

Lots of good advice already given... The 4-processor limit in Standard Edition refers to processor sockets on the motherboard, not to processor cores. Standard edition will run legally on...

Running SQL and IIS on a 2-server domain is not good practice. As already mentioned, best practice says that IIS should be isolated to its own server.

The...

At my old place we had some DTS packages that 'helpfully' changed the database mode while a load processes were running. Needless to say it took a while to...

This will also work if SQL Server 2005 is installed first as the default instance followed by SQL Server 2000 as a named instance. ...at least it worked OK...

mlavallee, I agree that with the system we have built for ourselves it is a pain to release slipstreamed software...

...but if you were given the task of releasing slipstreamed versions...

I assume you will put a monitor on commit load and run it for a few days to see if any time-dependant processes use more memory than the values you...

As the author of FineBuild, I would like to say a bit about what it can do...

One of the things FineBuild does is to encapsulate the install of SQL, SP,...

To try to bring this topic back to slipstreaming...

I think that all MS products should be available with the latest SP slipstreamed into the install media. This should definitely...

When you are working out how much memory is in use, you need to add the Commit Charge and the System Cache amounts together.

If the total is less...

Joe,

I have installed Vista on a 4GB box, both 32-bit and 64-bit, with no problems. It worked with AHDCI off and on. I did have problems finding drivers...

There is an innovative process called 'Non Disclosure Agreement' that can get round this problem. (OK, it was innovative when it was invented many decades ago...)

If the cilent's data...

I notice you are doing replication. Are you using CLR proceduers within your replication process. There is a known bug in using CLR within replication on 64-bit boxes...