Nothing is showing on GRANT?

FrankKalis

When I type in

GRANT EXECUTE ON dbo.blahblahblah TO

and then trigger SQL Prompt it is suggesting me only GUEST, PUBLIC, and all of the snippets, but none of my user-defined roles as I would expect. Am I missing some setting here?

Anu D

Thanks for your post and precise explanation of the issue.

I was able to replicate the issue.

I have logged this issue in our internal tracking system so that it will be addressed in our future release.

I have logged this issue as a bug whose reference number is SP-2766.

Kindly let me know if you have any other issue regarding SQL prompt, I'll like to help.

Anu D

Thanks for your patience this issue is now fixed with the latest update build.

For more details, kindly visit the following post.
http://www.red-gate.com/MessageBoard/vi ... php?t=9517