Posts
Sort by recent activity
SSMS 18 Command Line Invalid
I am unable to script directly to SQL Server Management Studio 18; instead I am presented with the command line syntax dialog for SSMS and then nothing.SQL Compare Version is 14.0.0.12866SSMS Versi...
Visual Studio integration broken after latest update (9.5.19.11631)
I applied update: 9.5.19.11631 to Visual Studio 2017 15.9.16Now the integration does not work. An uninstall, reinstall does not help.
Support for EVENTDATA() ?
Hello redgate folks. It would appear that SQL Prompt does not support the EVENTDATA() function, or perhaps it doesn't like the XML data type. I can't tell which. All I know is when the EVENTDATA fu...
Missing OBJECTPROPERTYEX property
The parameter suggestions for the OBJECTPROPERTYEX function is missing the property: TableTemporalTypeThere might be others, this is just one I encounter regularly.
Little things just stop working.
It seems like once a week some little feature of SQL Prompt quits working for me. This week, it's aligning data types in variable declarations. It used to work, then it just stopped--the setting is...
Single quotes not working
When I type the following SQL, everything works fine until the last single quote, consider this:SELECT * FROM [sys].[dm_xe_objects] AS [DXO] WHERE [DXO].[object_type] = N''As I'm typing, the single...
Import Settings File == No Effect
is there a secret to moving settings/styles from one SQL Prompt installation to another?
I've exported the settings from one instance of SP, and then imported into another and it had no effect. The...
Alternate CREATE VIEW syntax supported?
Some of use use (and support) an alternate CREATE VIEW syntax:CREATE VIEW [dbo].[MyView]
(
ColumnOne,
ColumnTwo,
ColumnThree
)
AS
SELECT a, b, c FROM [dbo].[MyTable];
After formatting w...
SQL Prompt does not recognize database context change
My SQL Prompt install (while in SMSS) does not recognize database context changes when performed by the toolbar/dropdown. The scenario usually goes something like this:
1. Open Query Window in msdb...
DMV columns appearing in Prompts
Often while typing, I am prompted with columns from various Dynamic Management Views.
For example, when I type:IF ISNULL(OBJECT_ID
I am prompted with the object_id column from sys.dm_qn_subsc...