Posts
Sort by recent activity
No intellisense for resource pool
Hi Redgate Team,unfortunately, SQL Prompt will not show the available resource pools (and workloads). If I remember correctly, in a previous version this was supported.Can you please fix it - thank...
Bug : ALTER SERVER CONFIGURATION
Hi Redgate Team,The following code cannot be formatted by SQL Prompt and I receive an error instead.Would be great to see a fix in the next release - thanks!ALTER SERVER CONFIGURATION SET MEMORY_OP...
BUG : Script Table / Partition scheme syntax error and missing in index definition
Hi Redgate Team,Hovering over a partitioned table, SQL Prompt does not add the partition column to the partition scheme which causes a syntax error. Also, no aligned index includes the partition sc...
No intellisense for ALTER PARTITION SCHEME / FUNCTION
Hi Redgate Team,unfortunately there is no intellisense for ALTER PARTITION SCHEME / FUNCTION .It would be great to see the list of partition functions and schemes when typing the command.Thanks a ...
Bug - with Recompile
Hi Redgate TeamSQLPrompt cannot format the following code.DECLARE @StatementAllTransactions nvarchar(4000)DECLARE @ParameterDefintionAllTransactions nvarchar(4000)DECLARE @_ParentAuthorityId intINS...
ALTER SERVER CONFIGURATION SET MEMORY_OPTIMIZED TEMPDB_METADATA=ON;
Hi Redgate Team,SQL Prompt will raise an error when formattingALTER SERVER CONFIGURATION SET MEMORY_OPTIMIZED TEMPDB_METADATA=ON;GOThanks for fixing!TorstenMVP
column names in table DDL bug
Hi Redgate Team,SQL Prompt formats the following code
CREATE TABLE dimension.date
(
ID_Date int NOT NULL
, Date date NOT NULL
, [Date] date NOT NULL
, Day smallint NOT NULL
, [Day] smalli...
Data type not lower case
Hi Redgate Teamthe data types are not converted to lower case anymore.Thanks for fixing!CREATE TABLE test
( id INTEGER IDENTITY(1, 1) NOT NULL , filler CHAR(1000) NOT NULL DEFAULT ('A'));GO
...
annoying bug
Hi redgate Team,there is an annoying bug which makes it hard to use SQL Prompt.Bug:1) Create a snippet and call the snippet #JobCategory for example2) Type GO into SSMS and press enter,3) SQL Promp...
Bug | ALTER DATABASE SET ENCRYPTION
Hi Redgate Team,SQL Prompt fails when trying to format the two code lines-- Suspend TDE encryptionALTER DATABASE AdventureWorks2017 SET ENCRYPTION SUSPEND;GOALTER DATABASE AdventureWorks2017 SET EN...