Thanks for reply Ralph,
I forget to mention - This is a transactional replication.
I am trying to find the way to update the master catalog to remove the
replication link.
Thanks,
STAN
-----Original Message-----
From: Davis Ralph
[mailto:mssqldba-ezmlmshield-x92895616.[Email address protected]
Sent: Friday, May 27, 2005 10:22 AM
To: LazyDBA Discussion
Subject: RE: Replication problem
My experience has been a nightmare trying to remove MS replication from a
database. It doesn't clean up completely even when you try to remove it.
We won't use it again unless forced to and then it will be on a standalone
server.
Thanks,
Ralph W. Davis
*********************************************************
*** CORPORATE DBA group - Houston ***
*********************************************************
-----Original Message-----
From: Sokolin Stan
[mailto:mssqldba-ezmlmshield-x52085002.[Email address protected]
Sent: Friday, May 27, 2005 9:01 AM
To: LazyDBA Discussion
Subject: Replication problem
Hi everybody
I am trying to alter table in user database .It have been under
replication. I disable replication(drop subscription
,publishing...restarted services , ect.)It still did not allows me to
alter/rename/drop table and it still showing that the database under
replication..
If anybody aware of the way to update system tables to force the database
drop the replication links?
Thanks in advance ,
STAN
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
-----------------------------------------
Confidentiality Note: The information contained in this message, and any
attachments, may contain confidential and/or privileged material. It is
intended solely for the person or entity to which it is addressed. Any
review, retransmission, dissemination, or taking of any action in reliance
upon this information by persons or entities other than the intended
recipient is prohibited. If you received this in error, please contact the
sender and delete the material from any computer.
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
MS Sql Server LazyDBA home page