Comments
Sort by recent activity
Jessica R wrote: »
Thanks all!
SQL Search does not search user-defined data types at the moment and I've created a request for this with reference SDI-724.
To confirm though, is SQL Prompt's "Select in Object Browser" option still not working for you with user-defined table types @Tawfik_Khalifeh_cme?
"select in object browser" is working for user defined table types / comments
Jessica R wrote: »
Thanks all!
SQL Search does not search user-defined data types at the moment and I've created a request for this with reference SDI-724.
To confirm though, is SQL Prompt's "S...
Same issue here, search and selection don't work for user defined table types, as well as f12 and other quick actions / comments
Same issue here, search and selection don't work for user defined table types, as well as f12 and other quick actions
Thought it would be better not to open a similar support ticket.
I use this feature quit often and it seemed reliable, up until it failed me once after deploying sql changes to production, there was an INSERT statement using an outdated column name that "find invalid objects" did not detect.
I can send you the problematic stored procedure if that helps, a pseudocode summary below
- insert data from user defined table type into a temp table
- insert data into db table using (insert into .. select .. join ..)
- the column that was invalid but not detected was in the insert column list / comments
Thought it would be better not to open a similar support ticket.
I use this feature quit often and it seemed reliable, up until it failed me once after deploying sql changes to production, there wa...