You can go for Active/Active clustering. But something you need to be aware about is that Active/Active Clustering will not be helpful to balance the load. To balance the load,...

Start sql with trace flag 3608 and you should be able to change the ownership of the database.

I looked at BOL and i did not find anywhere where it says that Standard edition will not create index in parallel. Can you please provide the link where it says so.

The small virtual log files is the growth increment which you provide for your transaction logs. Suppose if you have the logfile set to default limits of 10 % increment...

The database owner for some of your database is not a valid login. Try running the following query and change the ownership of all the databases which have null as the...

Are you runnng Active/Active or Active/Passive clustering ?

SQL Server does not support network load balancing. Yukon also does not have this feature. I think we might have to wait for the next product release.

How big is the Source Column ?

Profiler does involve overhead but you also don't have any options.

You can pick up a standard template to run and it should give you all...

You can write a trigger to accomplish this. You cannot cascade to two different columns.

Can you verify the MDAC versions on test and production ?

You might want to look at the article below.

http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B555064

Syscomments has a limitation of 4000 characters. You can use the script below. Paste it into a file and name it procedure.vbs(or anything else) and pass the parameters to the...

Below is the link to the KB Article which explains how to manually uninstall SQL server.

http://support.microsoft.com/default.aspx?kbid=290991