Using SQL prompt 4 within VS 2010

GrahamGoodwin

Am I correct in assuming that SQL Prompt only functions correctly in Visual Studio 2010 T-SQL-Editor when a connection has been established to the relevant database?

This means that it does not work with the internal VS database model and any changes made to the VS database project have to be deployed before SQL Prompt recognises them (eg. field name changes, new views etc)?

Many thanks

Graham Goodwin

David Atkinson

Yes, this is how it current works. It needs to have a connection to a real database. It is possible that we develop a version that works on the offline Database Project model, although this will depend on customer demand and so far it hasn't been that strong. If anyone else is looking for this ability we'd love to hear from you!

Is there any particular feature you're looking for that isn't available in VS2010's built-in Intellisense?

Kind regards,

David Atkinson
Product Manager
Red Gate Software

GrahamGoodwin

Thanks for your reply David. Perhaps the main thing I miss when no connection has been established is that, when creating a table, the list of available data types does not display correctly after typing a field name and pressing space. The prompt list display 'AS', 'DOUBLE', 'NATIONAL' and 'XML' as the first 4 options.

Regards

Graham Goodwin

wsoranno

David,
I would like to have the following feature in VS. When a file is created/opened, connect to the server and database specified in the project properties. If the "Target Connection" has not been set, then prompt for the connection information.

This would allow SQL Prompt to function more closely like it does in SSMS.

youngcm2

I think that you should at least the default sql objects listed.