Activity overview
Latest activity by MobyDX
Thanks. I have installed the beta and it seems much "safer" :-) / comments
Thanks. I have installed the beta and it seems much "safer" :-)
The cross-database suggestions seem to cause completions to explicitly reference the database-name when the database contains a schema with the same name. I have a database with the name ERP which, unfortunately, also has a schema called ERP. When I start typing "ERP." I correctly get a list of tables in that schema, but when I select one of them, it expands this to "ERP.ERP.<table-name>", i.e. specifying both the database-name and the schema-name. If I use auto-complete without typing "ERP." first (i.e. just start typing the first letters of the table-name), it only adds the schema-name, as before.
This can be quite dangerous if it goes unnoticed by whoever writes it. (For example if a stored procedure referencing "ERP.ERP.some_table" is run in database "ERP_test" on a server which also contains a database called "ERP"). / comments
The cross-database suggestions seem to cause completions to explicitly reference the database-name when the database contains a schema with the same name. I have a database with the name ERP which,...