There are reviews of Red Gate and Apex on this site:

http://www.sqlservercentral.com/columnists/awarren/sqlcomparereview.asp

http://www.sqlservercentral.com/columnists/chedgate/reviewofsqldiffbylockwood.asp

You can use VBScript and DMO to accomplish this:

http://www.nigelrivett.net/DMOScriptAllDatabases.html

Thanks, if you click the problem report, there is a form.

I just clicked "search" and entered "Rights" and click scripts and it worked.

This was a submitted question and I apologize about the right paren in #2 being so far to the right. HOWEVER, it is there.

It is something of a trick question,...

The explanation was incorrect and I had assumed this to be some undocumented feature. However as pointed out, "middle" acts as an alias. There is no middle join, however those...

Do you know the selectivity of the various fields? If some are more selective, i.e., a query will return very few rows, then these are great candidates for the first...

If the drive structure is the same, restore master and msdb after you've installed QSL on the new machine. If not, you need to backup all your DTS packages manually....

prerelease: http://www.sqlservercentral.com/columnists/WFillis/analternativexmlsolution.asp

dtsrun will execute procedures. You will need to redistribute some DLLs for this.

Should be in the cube poroperties or definition.

I'd dig into the data. If it's returning things you don't expect, I usually look for data problems.

Above is a great explanation.

Data Compare from Red Gate. Cheap, easy and works well.

http://www.red-gate.com/SQL_Data_Compare.htm

Are you bulk inserting? If not, you can get teh value first and then include it in the insert statement.

Server side traces use less resources, but you have to worry about file or table contention on the disks. You can always transfer the data to a remote server on...