Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Fixing reference to the object Expand / Collapse
Author
Message
Posted Saturday, December 22, 2012 11:33 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, November 27, 2014 11:13 PM
Points: 95, Visits: 387
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.
Post #1399696
Posted Saturday, December 22, 2012 11:40 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, November 27, 2014 11:13 PM
Points: 95, Visits: 387
This issue is for SQL Server 2000
Post #1399697
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse