SQL Replication

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Bryan Harris (bharris_at_ntihc.com)
Date: 11/30/04 

Date: Mon, 29 Nov 2004 22:27:01 -0600

I am trying to detach a SQL 7.0 DB, but QA tells me:

Server: Msg 3724, Level 16, State 1, Line 1
Cannot drop the database 'NTI_Precision' because it is published for
replication.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.

However when I go to EM and click on the "View Replication Conflicts..." for
that DB it tells me it is not a publisher or subscriber.

If this is actually replicating, I do not want it to. We have one
standalone SQL7 server and we are upgrading to a new SQL 2000 standalone
server. Is there a way to make this messgae quit occurring? Any help is
deeply appreciated!

Thanks,
Bryan

Relevant Pages

  • Re: SQL CE Interface and Web App Interface
    ... It seems like that when we tried to insert a new row using the SQL Management ... and the change did not go through the replication agent that it would ... The only issue you should have in writing to the pub database from a web app ... It is a common scenario for Corporate users to hit the Publisher, ...
    (microsoft.public.sqlserver.replication)
  • could not read file snapshot.pre due to OS error 5
    ... I am new to this replication thing and got bogged down on this issue. ... Subscriber, SQL 2005, existing on non-trusted domain, login xxxx ... Publisher can create a snapshot but Subscriber seem to have problem. ...
    (microsoft.public.sqlserver.replication)
  • Re: about transaction replication...
    ... This error is caused because sysdepends is out of sync on your publisher. ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: MSSQL replication to a desktop database
    ... subscriber to the SQL 2000 merge publisher. ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: Deleting Large Quantiy of Rows
    ... >From what you are saying it looks like these rows on the subscriber are read ... > my users are using MSDE 2000 with merge replication, publisher is SQL ...
    (microsoft.public.sqlserver.replication)