Article

Unable to delete publication

If you need to iterate over each table, sp_MSForEachTable will do the trick.  I recently needed to mark each table as replicated to that I could change the log (not a production server).  This did the trick:

exec sp_MSForEachTable @command1 = " EXEC sp_msunmarkreplinfo '?'"

Comments Closed.