Frank Kalis

Frank Kalis

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