Activity overview
Latest activity by c.jordan.mc
Version 11.4.3.26 professional / comments
Version 11.4.3.26 professional
User Defined Table Type Dependencies not always deployed
We often use the SQL Compare command line application to deploy changes from one SQL Azure Database to another. In some cases, when deploying a change to a user defined table type, the dependencies...
We are also using SQL Prompt v5.3.4.1 within our organization and are experiencing a similar issue.
When a SQL file is opened within an SSDT project in VS 2010, SQL Prompt suggestions work for SQL Keywords, local stored procedure variables, etc. In order to get suggestions for database objects, we need to connect to the database using the Connect to Server menu item...
Once connected to the database, SQL Prompt works correctly, but as soon as a new file is opened, we need to use Connect to Server again.
Because of this, it's actually more convenient to disable SQL Prompt suggestions and use the intellisense provided by SSDT. However, each time we open the SSDT project we have to enable SSDT intellisense. SSDT intellisense seems to be defaulting to disabled since we installed SQL Prompt. / comments
We are also using SQL Prompt v5.3.4.1 within our organization and are experiencing a similar issue.
When a SQL file is opened within an SSDT project in VS 2010, SQL Prompt suggestions work for SQL ...