No Code Suggestions on New Objects in VS Database Project

sundance15

I am not getting any code suggestions on new objects created in a Visual Studio 2013 database project. I'm using SQL Prompt version 6.4.1.164.

Thanks!

Aaron L

Hi sundance15,

After you've deployed the changes to your database you can refresh Prompt's suggestions with Ctrl+Shift+D (or "Refresh Suggestions" from the SQL Prompt menu).

Alternatively you can use the experimental auto-refresh feature which can be turned on through SQL Prompt->Options->Experimental Features to automatically detect the changes in your database.

Thanks,
Aaron.

sundance15

Thanks for the reply. I'm very surprised that SQL Prompt can't use the project as the connection. Guess I'll put in my two cents in the User Voice forum.

For anyone who would like this feature, please vote here:
http://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/5985591-load-suggestions-from-sql-files-in-visual-studio-s

Thanks!

Aaron L

Thank you for voting!

It's something that we really want to implement but we've got a few other features that are seen as a higher priority so it's hard to justify it over them at the moment. Once we've got some of those implemented we can turn our attention to improving this.

Thanks,
Aaron.