What are the challenges you face when working across database platforms? Take the survey
Options

renames table name and overwrites referenced DB name.

slickmeisterslickmeister Posts: 2
edited April 17, 2007 12:30PM in SQL Refactor Previous Versions
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.

Comments

  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hi,

    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?
Sign In or Register to comment.