How to Remove Merge Replication?

Hi All:
I have setup Merge Replication (Push) & we are using SQL2000 sp3.
After testing a few things, I disabled the Publication. This did not remove
Subscription on the other Server.
I have a task stuck in Subcriptions, under Replication on SQL.
It Shows the Task as 'Running' Status and Last Action as 'Syncronization in
Progress'
Now I am not able to delete the table in the subscriber also, as it says
'This table has been setup from Replication'
Please suggest.
Thanks,
Anukul
You can use sp_removedbreplication 'dbname' on publisher and subscriber to
remove the system tables associated with replication.
If needed, there is a stored procedure to remove the replication setting on
a table called sp_MSunmarkreplinfo which takes a tablename as a parameter.
Alternatively, setting replinfo to 0 in sysobjects for the particular table
should do it.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Thanks Paul:
I did try this procedure & was able to remove the system tables, including
the Job I mentioned. But it was still not letting us alter the structure or
drop the tables on which Replication was setup.
Please let me know what am I doing wrong.
Regards,
Anukul
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:OHL64kGAFHA.1396@.tk2msftngp13.phx.gbl...
> You can use sp_removedbreplication 'dbname' on publisher and subscriber to
> remove the system tables associated with replication.
> If needed, there is a stored procedure to remove the replication setting
on
> a table called sp_MSunmarkreplinfo which takes a tablename as a parameter.
> Alternatively, setting replinfo to 0 in sysobjects for the particular
table
> should do it.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||Anukul,
did you try sp_MSunmarkreplinfo?
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Hi Paul:
I did try that one out also & BTW I am now able to remove Subscriber.
Thanks a Lot for ur help.
Regards,
Anukul
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:155e01c5023b$3917e340$a501280a@.phx.gbl...
> Anukul,
> did you try sp_MSunmarkreplinfo?
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||I would be interested in hearing from the community if anyone is having the
same type of problems on SQL 2005. We added a force option to sp_removed
which more aggressively drops replication objects. Additionally, we now drop
any rowguid columns that were added in merge.
Philip Vaughn
Program Manager
SQL Server Replication
This message is provided "AS IS" with no warranties, and confers no rights.
"Anukul" <anukuls@.yahoo.com> wrote in message
news:OCJxPYmAFHA.1388@.TK2MSFTNGP09.phx.gbl...
> Hi Paul:
> I did try that one out also & BTW I am now able to remove Subscriber.
> Thanks a Lot for ur help.
> Regards,
> Anukul
> "Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
> news:155e01c5023b$3917e340$a501280a@.phx.gbl...
>

How to redirect a DTS package and connections

Hi,

I have a DTS package (SQL2k, sp3) that I can to execute agains a new
database in the same server. I don't see how to easily redirect. If you
change the connection properties and clear the transformations you have to
redo them one at a time (too long).

If you don't data still goes to the old database.

What to do?

Sd"SD" <npspam@.nowhere.net> wrote in message
news:483161980e01c04754af03e36c264ae2@.news.teranew s.com...
> Hi,
> I have a DTS package (SQL2k, sp3) that I can to execute agains a new
> database in the same server. I don't see how to easily redirect. If you
> change the connection properties and clear the transformations you have to
> redo them one at a time (too long).
> If you don't data still goes to the old database.
> What to do?
> Sd

Check out the dynamic properties task - it allows you to set any properties
dynamically as the package is running. In this case, you could have a global
variable to store the database name, and use the task to assign it to the
connection. At runtime, you can pass the value for the global variable to
dtsrun.exe, or get it from an .INI file or SELECT query.

Simon

How to raise the number of Named Pipes on the SQL Server 2000

hi,
can someone tell me how to raise the number of Named Pipes on SQL 2000 SP3,
please? i am aware of http://support.microsoft.com/?id=165189 and the hereby
mentioned registry key, which is for SQL 6.0/65. but no one can tell me what
to use in case of sql server 2000, beside of pointing me to the client side,
which is not wanted.
thanks, fritzHi
Any reason you don't want to use the more efficient TCP/IP connections?
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Fritz Theiss" <michschu67@.hotmail.com> wrote in message
news:uiN6MxRkFHA.3436@.tk2msftngp13.phx.gbl...
> hi,
> can someone tell me how to raise the number of Named Pipes on SQL 2000
> SP3, please? i am aware of http://support.microsoft.com/?id=165189 and the
> hereby mentioned registry key, which is for SQL 6.0/65. but no one can
> tell me what to use in case of sql server 2000, beside of pointing me to
> the client side, which is not wanted.
> thanks, fritz
>|||the application needs to...
thanks, fritz
"Mike Epprecht (SQL MVP)" schrieb:

> Hi
> Any reason you don't want to use the more efficient TCP/IP connections?
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Fritz Theiss" <michschu67@.hotmail.com> wrote in message
> news:uiN6MxRkFHA.3436@.tk2msftngp13.phx.gbl...
>
>

How to raise the number of Named Pipes on the SQL Server 2000

hi,
can someone tell me how to raise the number of Named Pipes on SQL 2000 SP3,
please? i am aware of http://support.microsoft.com/?id=165189 and the hereby
mentioned registry key, which is for SQL 6.0/65. but no one can tell me what
to use in case of sql server 2000, beside of pointing me to the client side,
which is not wanted.
thanks, fritz
Hi
Any reason you don't want to use the more efficient TCP/IP connections?
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Fritz Theiss" <michschu67@.hotmail.com> wrote in message
news:uiN6MxRkFHA.3436@.tk2msftngp13.phx.gbl...
> hi,
> can someone tell me how to raise the number of Named Pipes on SQL 2000
> SP3, please? i am aware of http://support.microsoft.com/?id=165189 and the
> hereby mentioned registry key, which is for SQL 6.0/65. but no one can
> tell me what to use in case of sql server 2000, beside of pointing me to
> the client side, which is not wanted.
> thanks, fritz
>
|||the application needs to...
thanks, fritz
"Mike Epprecht (SQL MVP)" schrieb:

> Hi
> Any reason you don't want to use the more efficient TCP/IP connections?
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Fritz Theiss" <michschu67@.hotmail.com> wrote in message
> news:uiN6MxRkFHA.3436@.tk2msftngp13.phx.gbl...
>
>