Author: Frank Kalis
An aggregate may not appear in the OUTPUT clause.
Each GROUP BY expression must contain at least one column that is not an outer reference.
The IDENTITY function can only be used when the SELECT statement has an INTO clause.
Cannot specify a log file in a CREATE DATABASE statement without also specifying at least one data file.
A SELECT INTO statement cannot contain a SELECT statement that assigns values to a variable.
Spotlight on ApexSQL Diff – Server-based database comparison tool
Embarcadero DBArtisan – cross-platform database administration solution
Idera SQL Change Manager
ApexSQL Doc: SQL Server Documentation Tool