Re: SQL Replication

From: Des FitzGerald (dfitz_at_dr-sql.com)
Date: 11/30/04 

Date: Tue, 30 Nov 2004 10:13:56 +0100

Hi Bryan,

In Query Analyser run the following:

Sp_replicationdboption ŒNTI_Precision¹, ŒPUBLISH¹, FALSE
Go
Sp_replicationdboption ŒNTI_Precision¹, ŒMERGE PUBLISH¹, FALSE

This will remove the database from being a merge or transactional publishing
database and you should then be able to detach the database.

HTH,

Cheers,
Des

On 30/11/2004 05:27, in article
mESqd.11517$Ae.2482@newsread1.dllstx09.us.to.verio.net, "Bryan Harris"
<bharris@ntihc.com> wrote:

> 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: publishing more than one database
    ... Director of Text Mining and Database Strategy ... Looking for a SQL Server replication book? ... Recently we have a need to publish the second database on the same SQL ... for publishing a second or third etc is no difference than publishing the ...
    (microsoft.public.sqlserver.replication)
  • Re: Adding Printers to AD
    ... You'd need an enormous database to ever need to worry about this. ... A group policy was put in place some time ago for not publishing printers to AD. ... The more objects placed in Active Directory the larger the database grows, which can cause greater chance of corruption b.. ... The larger the database the longer it takes for AD replication to complete. ...
    (microsoft.public.win2000.active_directory)
  • replication
    ... Using merge replication, we made some schema changes to the publishing ... database. ...
    (microsoft.public.sqlserver.replication)
  • Re: drawbacks of Saving documents to Sql server
    ... Bryan, thanks for yor reply and got some more questions for you. ... document to the user when it is stored in the database. ... SQL Server 2005 performs better than SQL Server 2000 hands down. ... that microsft is gong more towars saving everthing in sql server. ...
    (microsoft.public.dotnet.framework)
  • Re: SQL Replication
    ... Hi Bryan, ... This will remove the database from being a merge or transactional publishing ... > replication. ...
    (microsoft.public.sqlserver.server)