Re: 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: 12/13/04 

Date: Mon, 13 Dec 2004 14:50:05 -0600

Re: SQL ReplicationWorked like a champ.

Thanks,
Des
"Des FitzGerald" <dfitz@dr-sql.com> wrote in message
news:BDD1F864.111C%dfitz@dr-sql.com...

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: SQL Replication
    ... Hi Bryan, ... This will remove the database from being a merge or transactional publishing ... > replication. ...
    (microsoft.public.sqlserver.server)
  • Re: Errors in Directory Service Event Viewer
    ... >condition persists then please restore the database from a previous backup. ... >following directory partition. ... >Sites and Services for the KCC to create a spanning tree replication ... >- Add a Connection object to a domain controller that contains the directory ...
    (microsoft.public.windows.server.active_directory)