renames table name and overwrites referenced DB name.
slickmeister
Posts: 2
Hi,
I ran the Smart Rename on one of my tables. Some of the procs that reference this table, also reference a table of the same name but on a different database. The problem that I am experiencing is that the referenced database and table name are getting overwritten with the new table name. Is this something that you are aware of, and if so, how can it be overcome?
Thanks.
I ran the Smart Rename on one of my tables. Some of the procs that reference this table, also reference a table of the same name but on a different database. The problem that I am experiencing is that the referenced database and table name are getting overwritten with the new table name. Is this something that you are aware of, and if so, how can it be overcome?
Thanks.
Comments
I do not think that Refactor will include database names when it qualifies objects, because this is not part of the design of the software.
I have logged your comment as a suggestion for future development.
In the meantime, can I ask if this actually causes a problem for you such as invalid object references or errors?