Visual Studio 2008 For Database GDR no prompt
bpeikes
Posts: 2
If I click on "New Query" from the ribbon in VS 2008.
Begin writing query, example
SELECT *
FROM
and then hit Ctrl-Space. I get the redgate prompt, but "No suggestions"
I've selected Refresh Cache from the menu, but that doesn't help.
Any ideas?
It works perfectly fine when I use Sql Server Management Studio.
It also will come up with suggestions for variables or functions, but not table names or columns.
The problem if you are in any part of a query which takes a table name.
Begin writing query, example
SELECT *
FROM
and then hit Ctrl-Space. I get the redgate prompt, but "No suggestions"
I've selected Refresh Cache from the menu, but that doesn't help.
Any ideas?
It works perfectly fine when I use Sql Server Management Studio.
It also will come up with suggestions for variables or functions, but not table names or columns.
The problem if you are in any part of a query which takes a table name.
Comments
I created a new SQL Server 2005 Database project. I use 'Import Database Objects and Settings' to populate the project from a live DB and I edit a stored procedure.
SQL Prompt (and Visual Studio) don't associate this file with the original database. It's just a flat file. So all of the auto completion from SQL Prompt is pretty much empty.
The workaround is to click 'SQL Prompt' --> 'Connect to Server' and open the saved connection that points to the live database. I have to do this every time I open any SQL file in the project.
Of course, this will only work until the changes you've made in the project cause the live database to be too far out of sync. Since I'm mostly dealing with stored procedure changes (as opposed to schema changes), this is still a pretty useful workaround.