Posts
Sort by recent activity
QUERY_CAPTURE_MODE = CUSTOM
Hi Redagte Team,SQL Prompt will raise on error formatting the following code:ALTER DATABASE CurrentSET QUERY_STORE (OPERATION_MODE = READ_WRITE, QUERY_CAPTURE_MODE = CUSTOM)GOThanks for fixing!
WAIT_STATS_CAPTURE_MODE
Hi Redgate Team,SQL Prompt will not format the following code and reports an error.Thanks for fixing!USE [master]GOALTER DATABASE [AdventureWorks2017] SET QUERY_STORE (OPERATION_MODE = READ_WRITE, ...
Bug
Hi Redgate Team,since the last update SQL Prompt will add a semicolon to the following code -- Clear the query storeALTER DATABASE current SET QUERY_STORE CLEAR ALL;GO-- Semicolon is addedSET; STAT...
ACCELERATED_DATABASE_RECOVERY
Hi Redgate TeamIt seems that ACCELERATED_DATABASE_RECOVERY is not yet supported by the intelliSense. Would be great to add this option - thanks!-- enable ADRALTER DATABASE CURRENT SET ACCELERATED_D...
Bug - No suggestion for data types in table create statement anymore
Hi Redgate Team,Since the last update SQL Prompt will not suggest any data types when writing a table create statement.Start typing the following statement will miss any data type suggestionCREATE ...
Indentation
Hi Redgate Team!SQL Promt will not indent the ROLLBACK which is not correct.Would be great to see a fix -thanks!Torsten -MVP
Partition function
Hi Redgate Team,SQL Prompt will add an additional space before the data type which is not needed.Thanks for fixing!TorstenMVP-- Create a partition functionCREATE PARTITION FUNCTION pf (date) -- p...
Bug With Fillfactor
Hi !The following syntax will successfully parsed but SQLPrompt will raise an error.ALTER TABLE one_side ADD CONSTRAINT PKCL_one_side_col1 PRIMARY KEY (col1)WITH FILLFACTOR = 100;GOThe official syn...
Filegroup / Error
Hi !I have a database with two file groups. One is defined as default the other is named index.-- !Change the path according to your server configuration-- !Consider to send the index file and log ...
Loading window on tempdb
Hi!If you work in the scope of the tempdb, the Loading Metadata windows appears very often which is annoying.Is there a way to hide this window generally ?Thanks!Torsten