SmartRename misses dependencies

[George Palacean]

If a view references a table using the three-part identifier (even if it's in the same database), then it will not be changed when smartrenaming the table.

Ex:
create view testview
as
select * from databasename.dbo.tablename


but it works if the view is defined like this:
create view testview
as
select * from dbo.tablename

[eddie davis]

Thank you for your post into the forum and sorry that you have encountered this problem

I have tested as per your example and replicated your problem.

I have created a Bug Report for the development team to consider. The reference for the Bug Report is SR-590. Hopefully the development team will rectify this bug in a future version of SQL Refactor.

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com