I need to rename some tables in my DB - SQL Server 2005, with this:
EXEC sp_rename 'dbo.TableName', 'Tmp_TableName', 'OBJECT'
but I can't do this - I get this exception -
Cannot rename the table because it is published for replication
This DB doesn't have replication - it was removed 5 years ago - we've just tried it and removed it after a week. So I suppose that it should be a flag somewhere.
Please help me remove this flag somehow.