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.

Cannot convert a nonclustered index to a clustered index online using DROP_EXISTING option. - 13 Oct 2009

Cannot create the clustered index “%.*ls” on view “%.*ls” because the select list of the view definition does not include all columns in the GROUP BY clause. Consider adding these columns to the select list. - 14 Sep 2009

Cannot create the clustered index “%.*ls” on view “%.*ls” because no row can satisfy the view definition. Consider eliminating contradictions from the view definition. - 14 Sep 2009

There are no matching rows on which to report. - 13 Sep 2009

Error %d, severity %d, state %d was raised, but no message with that error number was found in sys.messages. If error is larger than 50000, make sure the user-defined message is added using sp_addmessage. - 13 Sep 2009

Query processor could not produce a query plan because of the hints defined in this query. Resubmit the query without specifying any hints and without using SET FORCEPLAN. - 13 Sep 2009

DROP XML INDEX does not support any options. - 13 Sep 2009

Only functions and extended stored procedures can be executed from within a function. - 12 Sep 2009

INSERT EXEC failed because the stored procedure altered the schema of the target table. - 12 Sep 2009

Cannot issue SAVE TRANSACTION when there is no active transaction. - 12 Sep 2009