SQLServerCentral / SQL Server 7,2000 / SQL Server Newbies / Fixing reference to the object / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 06:07:21 GMT20RE: Fixing reference to the objecthttp://www.sqlservercentral.com/Forums/Topic1399696-169-1.aspxThis issue is for SQL Server 2000Sat, 22 Dec 2012 11:40:16 GMTKnowledge HunterFixing reference to the objecthttp://www.sqlservercentral.com/Forums/Topic1399696-169-1.aspxHello,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.Sat, 22 Dec 2012 11:33:06 GMTKnowledge Hunter