Hello:
I have a SQL database which (at one point) was set up for a matter of a day for replication. Replication was removed, but the constraints and msrepl_tran_versoin columns still exist in 500+ tables. I want to remove it.
I used the syntax @
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=175697
and it removed the constraint in the article as specified. When I tried to remove the column I receive the error:
The statistics 'msrepl_tran_version' is dependent on column 'msrepl_tran_version'
ALTER TABLE DROP COLUMN msrepl_tran_version failed because one or more objects access this column.