Comments
Sort by recent activity
Great, thank you! / comments
Great, thank you!
SQL Prompt will script without brackets (if the SP doesn't have them) when scripting as long as I use F12 -- this is exactly what I'd like to happen. It looks like scripting from the object explorer will always add in the brackets.
I generally like ctrl+ky, but I like some SPs just the way they are, so I'd like to keep the code formatting the way it is by default. / comments
SQL Prompt will script without brackets (if the SP doesn't have them) when scripting as long as I use F12 -- this is exactly what I'd like to happen. It looks like scripting from the object explore...
You're right, I just tested this by uninstalling SQL Prompt. I feel bad for accusing SQL Prompt for a crime that it didn't commit. [image]
Is there any way to have SQL Prompt automatically remove brackets in the database/schema/object name when scripting objects? I know I can use shortcuts like "ctrl+BB", but if it could do it automatically it'd make me very, very happy. / comments
You're right, I just tested this by uninstalling SQL Prompt. I feel bad for accusing SQL Prompt for a crime that it didn't commit.
Is there any way to have SQL Prompt automatically remove brackets...
Great, thanks! / comments
Great, thanks!
It doesn't autocomplete any keywords inside the trigger. So suggestions for "declare" or "int" aren't showing. I am on the latest version of SQL Prompt (8.0.8.2086, just upgraded today). The problem also occurred on 8.0.7.1917.
I disabled and re-enabled suggestions and the problem persists.
edit: Here are two screenshots that show the autocomplete inside an SP working, but not working inside the trigger.
SP: [image]
trigger: [image] / comments
It doesn't autocomplete any keywords inside the trigger. So suggestions for "declare" or "int" aren't showing. I am on the latest version of SQL Prompt (8.0.8.2086, just upgraded today). The proble...
The autocomplete isn't showing up inside the logon trigger. The only suggestions that come up are from snippets. / comments
The autocomplete isn't showing up inside the logon trigger. The only suggestions that come up are from snippets.
That uservoice is exactly what I mean. I voted for it, thanks. / comments
That uservoice is exactly what I mean. I voted for it, thanks.
Works great, thank you! / comments
Works great, thank you!
I just upgraded to the beta and it works great. Thanks for the quick reply. / comments
I just upgraded to the beta and it works great. Thanks for the quick reply.
I had a similar problem. I was missing a lot of results. I deleted the cache inside %appdata%, and that fixed it for me. / comments
I had a similar problem. I was missing a lot of results. I deleted the cache inside %appdata%, and that fixed it for me.