sql server replication: Problems Removing Replication -- sql server replication

Problems Removing Replication

Matt D.
10/6/2003 10:36:11 AM

sql server replication:

I have a product that I am running that I am trying to
upgrade. I am running this product on SQL2000. When I
run my script it give me the following error for a few
tables;

Server: Msg 4929, Level 16, State 2, Line 1
Cannot alter the table 'BillingRatesEffectiveDates'
because it is being published for replication.

I do not have replication running on my test machine or
the production server that I got the database from.
There are no Publications or Subscriptions. I have a
feeling that it was set up at one point but was removed.
I am wondering how to release replication on the tables

Problems Removing Replication

Hilary Cotter
10/6/2003 12:05:48 PM

try running this script
http://groups.google.com/groups?
selm=3bccc79e.0307241027.2b97ec7%
40posting.google.com&output=gplain

[quoted text, click to view]

RE: Problems Removing Replication

rboyd NO[at]SPAM onlinemicrosoft.com
10/8/2003 6:22:38 PM

SQL Server provides a stored procedure to do this. The procedure is
sp_removedbreplication. It takes one parameter - the database. It is
documented in Books on Line.

Rand

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server replication group.