Hello,
I have swapped the names for multiple tables using sp_rename.
The SPs and views which were associated with it are working fine but the reference to the objects is still pointing to the renamed object.
Is there any of fixing the reference in bulk without dropping and recreating the associated objects?
Thanks in Advance for your help.