Posts
Sort by recent activity
Error when connectiong to Azure SQL Database
Hi Redgate Team,I can no longer access an Azure SQL database. I get the attached error message and can therefore no longer use the tool. I have already uninstalled and reinstalled SQL Doc without s...
Missing important Information
Hi guys,I really like SQLDoc, but it is missing some very important information.For the SQL database, the size, computation tier, etc. are missing. Adding details about the query store is also very...
EXTERNAL Table, Data_Source, etc.
Hi guys,The syntax "External Table", "External Data_Source", etc. is not considered by the formatting template, instead SQL prompt even convert it to a sigle row.CREATE EXTERNAL DATA SOURCE mydatas...
Log reuse wait NOTHING
Hi guys,can you please remove "Log reuse wait NOTHING" from the overview of the database. It makes no sense since this property is a wait type.Thank you!TorstenMVP
CREATE USER [xyz] FOR EXTERNAL PROVIDER WITH OBJECT_ID = '12354-5c5b-4860-9f' failing
Hi Redgate Team,SQL Prompt fails when formating the valid syntax CREATE USER [xyz] FOR EXTERNAL PROVIDER WITH OBJECT_ID = '12354-5c5b-4860-9f';GOThank you for fixing!
Bug / Create user
Hi Redgate Team,SQL prompt adds a semicolon after the user name which makes the code invalid.Latest SQL Prompt version is installed.CREATE USER [P-98-METRICS-ADVISOR-SPN] FOR EXTERNAL PROVIDERGO
CR...
missing format / word wrap
Hi guys,it seems that there is no meaningful word wrap / formatting for-- Create external data sourceCREATE EXTERNAL DATA SOURCE xyz WITH(LOCATION='sqlserver://myserver', PUSHDOWN=ON, CREDENTIAL=[m...
Bug / AS
Hi Team,; WITH duplicates_cte AS ( SELECT * , HASHBYTES ( 'MD5' , CONCAT ( TRIM ('_.|' FROM requestId) , eventTime ) ) AS h...
No IntelliSense for OPTION in Procedure anymore
Hi Redgate Team,The IntelliSense for "Option" is not working anymore when creating a procedureCREATE PROCEDURE Sales @MaxOrderDate datetimeASSELECT TOP 10000 sod.SalesOrderID, sod.OrderQty, sod.Uni...
Bug / CREATE USER FROM EXTERNAL PROVIDER
i Redgate Team.SQL Prompt will add a semicolon toCREATE USER MyAutomationAccount FROM EXTERNAL PROVIDER
CREATE USER MyAutomationAccount; FROM EXTERNAL PROVIDER
which will cause a syntax error.Than...