• If you attempt to modify a table that's currently being replicated, you will receive the following error

    - Unable to modify table.

    Cannot drop the table 'dbo.ts-services' because it is being used for replication.

    To obtian a list of table that are replicated you can run:select * from sys.objects where is_published = 1

    To get around it you have to remove the article from the publication, make the change, then add it back into the publication.

    How were you able to do this in your test?

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience