Cannot drop tablename because it is being used for replication

Posted At : May 30, 2008 3:22 PM | Posted By : Mark W. Breneman
Related Categories: Dev Notes

If you are getting the error "Cannot drop 'sometablename' because it is being used for replication" on MS SQL server and you don't have replication even running on the server and you restored the tables from a back up, (... and it is raining on an odd day of the month in July) there is a good chance that the table is still marked for replication.

sp_MSunmarkreplinfo <tablename>

Comments (0) | Print | Send | del.icio.us | Digg It! | Linking Blogs | 573 Views
Comments (Comment Moderation is enabled. Your comment will not appear until approved.)

There are no comments for this entry.

[Add Comment]
BlogCFC was created by Raymond Camden. This blog is running version 5.9.001. Contact Blog Owner