Turns out the problem is when I made the change the replication created
another column in all of the tables called....msrepl_synctran_ts. Now I need
to delete this form all the tables. How can I do this without going through
each one individually?
example:
alter (all_tables) drop column msrepl_synctran_ts

-----Original Message-----
From: Shawn Smith [mailto:[Email Address Removed] Tuesday, January 22, 2002 9:46 AM
To: Mssqldba Distribution List (E-mail)
Subject: Data issues


I switched form Snapshot replication to Transactional Replication over the
weekend. I ran out of space and had to disable replication all together
Monday. I am now getting reports form people that there is data issues.
Columns have changed and tables were dropped. Could the replication caused
this? I know in theory it should not effect any data, so it may just be a
coincidence. And if it is not how do I recover what was lost without
restoring form backup?


Shawn Smith
Database Administrator
[Email Address Removed] cell
817-667-2757 pager


---------------------------------------------------------------------
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page