I am trying to work on a SQL2000 server. It's a development box. Whenever we attempt to used a page with an UPDATETEXT statement, we get this error:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]UPDATETEXT is not allowed because the column is being processed by a concurrent snapshot and is being replicated to a non-SQL Server Subscriber or Published in a publication allowing Data Transformation Services (DTS).
/visec/tabs/remarks.asp, line 86
So, I figured that this copy of the database still had the old replication data in it. I created a new publication, then removed it, ran sp_repl_done and sp_removedbreplication. All completed without error, but I am still seeing the above.