New features added to SQL Prompt Watch now.

SQLPROMPT Error formatting query hint IGNORE_NONCLUSTERED_COLUMNSTORE_INDEX

Example:
SELECT * FROM sys.tables -- formatting works great
SELECT * FROM sys.tables OPTION (IGNORE_NONCLUSTERED_COLUMNSTORE_INDEX) --  formatting fails with error "Error laying out sql. SQL Prompt encountered internal problems while processing this script. Exception: Object reference not set to an instance of an object."
Tagged:

Answers

Sign In or Register to comment.