Posts
Sort by recent activity
Queue Support
SQL Prompt doesn't appear to support selecting from queues. Is this possible?use tempdb
<br>create queue testQueue
<br>select *
from testQueue
<br>drop queue dbo.testQueue
Disable gamebar prompt in remote desktop
While connect to a machine through remote desktop, whenever I hit CTRL to open the "quick launch menu" (the one to do things such as unformat, insert snippets, etc.) The menu in windows 10 "Select...
Server roles not populating with correct suggestions
Server roles are not populating with correct suggestions. When I type in "alter server role", I get the database roles, not server ones.
Tooltip placement for dual monitors
Is there a way to force a tool-tip to be placed on the same monitor when hovering over a function/column/etc. with the mouse? The issue I'm experiencing is the tool-tip often displays on my other m...
Expanding wildcard for @table variables not displaying computed columns
The expand wildcard feature is not working for @table variables. If I declare a @table with computed columns, then expand the wildcard, only the non-computed columns will be shown. For example:decl...
Placing parameters on a new line for stored procedures
How can I get SQL Prompt to place the first parameter on a new line? I tried these settings:- Lists --> Place first item on new line = Always- Place subsequent items on new lines = AlwaysIn the pre...
Certificate suggestions support
I noticed that certificates aren't completely supported. Is there any way to get these fully supported?use master
-- sql prompt works for this
create certificate tswift_cert encryption by password ...
Code analysis incorrect - alias
The code analysis for aliases isn't correct. For example, this query:select my_alias = o.name
from sys.objects o
Gives this issue: Old-style column alias via EQUAL sign. It is recommended to spec...
Brackets when scripting stored procedures
Is there any way to disable adding brackets around the database, schema, and stored procedure name when scripting a stored procedure? SQL Prompt is adding it in, even though the stored procedure it...
Logon Triggers Not Supported
I am unable to use SQL Prompt's autocomplete features within a logon trigger. Is there any way this can be supported?
Example:
use master
go
create trigger [trgAudit]
on all server
for logon
as
beg...