Another Issue with Rename
Janis
Posts: 2
I'm having a problem when trying to rename a view in DB#1 that references a table or view in DB#2.
The rename involved changing only the SchemaName portion of the name. There are no stored procedures that reference the views being changed (as was described in an earlier post about Rename problems).
The rename involved changing only the SchemaName portion of the name. There are no stored procedures that reference the views being changed (as was described in an earlier post about Rename problems).
Comments
Your post doesn't actually say what the problem actually is. If the issue is the dialog closes before the script is generated then the chances are that this is the same bug, regardless of whether it is a view or a stored procedure being renamed as SQL Refactor has an issue parsing cross database dependancies. The patch for this should be out in the next couple of days.
Regards,
Jonathan
-Project Manager
-Red Gate Software Ltd