Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-09-19 : 10:15:05
|
| Josh writes "Hello,I have a NT4.0 SQL 7.0 sp3 server that I can't drop a table from. The error says that the table is marked for publication. I have a couple of problems. One is that there isn't any publication or subscription going on. There was at one time a merge replication going on, but it has been removed for about 8 months. There are no other sqlservers on the network that are using replication at all. No subscriptions or publications. The 2nd problem was that before I came on board, someone thought that if they deleted the entry in syscolumns, it would go away. Now I have a table that is flagged for replication, and a column that is ''. I can't rename the column or drop it (i believe that it was originally a rowguid column. Any help would be appreciated...how can I unflag the table manually and remove a non visable column? The msmerge and replication tables are all truncated by the way. Thanks.Jharwood" |
|
|
|
|
|
table is flagged for publication, but there isn't any replication going on!