Simplifying Solutions
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.