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.

CREATE DATABASE permission can only be granted in the master database. - 03 Aug 2009

The check statement was aborted. DBCC CHECKCATALOG cannot be run on TEMPDB. - 03 Aug 2009

Implicit conversion from data type %ls to %ls is not allowed. Use the CONVERT function to run this query. - 03 Aug 2009

Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = %ld, current count = %ld. - 03 Aug 2009

The logical tables INSERTED and DELETED cannot be updated. - 03 Aug 2009

Cannot create the clustered index “%.*ls” on view “%.*ls” because the index key includes columns that are not in the GROUP BY clause. Consider eliminating columns that are not in the GROUP BY clause from the index key. - 03 Aug 2009

FILESTREAM_ON cannot be specified when a table has no FILESTREAM columns. Remove the FILESTREAM_ON clause from the statement, or add a FILESTREAM column to the table. - 03 Aug 2009

Cannot use TEXTIMAGE_ON when a table has no text, ntext, image, varchar(max), nvarchar(max), varbinary(max), xml or large CLR type columns. - 03 Aug 2009

Cannot set NOCOUNT to OFF inside the trigger execution because the server option “disallow_results_from_triggers” is true or we are inside LOGON trigger execution. - 03 Aug 2009

The last statement included within a function must be a return statement. - 03 Aug 2009

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |