Frank Kalis
http://www.insidesql.org/blogs/frankkalis/
Frank is working as a Development DBA / Data Architect for a large financial institution in Switzerland. He is a Microsoft MVP for Windows Server System - SQL Server since April 2005.
The conversion from datetime data type to smalldatetime data type resulted in a smalldatetime overflow error. - 12 Jul 2009
Cannot use index “%.*ls” on table “%.*ls” in a hint. XML indexes are not allowed in hints. - 12 Jul 2009
Index “%.*ls” on table “%.*ls” (specified in the FROM clause) is disabled or resides in a filegroup which is not online. - 12 Jul 2009
The index ID %d on table “%.*ls” (specified in the FROM clause) is disabled or resides in a filegroup which is not online. - 12 Jul 2009
The TABLESAMPLE clause can only be used with local tables. - 12 Jul 2009
Syntax error: Duplicate specification of the action “%.*s” in the trigger declaration. - 12 Jul 2009
The IDENTITY function cannot be used with a SELECT INTO statement containing a UNION, INTERSECT or EXCEPT operator. - 12 Jul 2009
The NOLOCK and READUNCOMMITTED lock hints are not allowed for target tables of INSERT, UPDATE or DELETE statements. - 12 Jul 2009


