Can't Disable, getting Server Cannot obtain LOCK

Internet merge replication. Need to detach to move to a new box. Deleted
all the publication, now when I try to disable it as the publisher. I tried
to run sp_removedbreplication 'db_name' and get the same message.
Any thoughts?
Thanks
After lots more reading and searching, I found low memory could cause this.
I added another 512 to the box, and it worked.
"SteveInBeloit" wrote:

> Internet merge replication. Need to detach to move to a new box. Deleted
> all the publication, now when I try to disable it as the publisher. I tried
> to run sp_removedbreplication 'db_name' and get the same message.
> Any thoughts?
> Thanks
|||I would have bounced the server and then tried this - this is abnormal.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"SteveInBeloit" <SteveInBeloit@.discussions.microsoft.com> wrote in message
news:17E5CBD0-5D2A-444A-97BD-4629B2AE3559@.microsoft.com...[vbcol=seagreen]
> After lots more reading and searching, I found low memory could cause
> this.
> I added another 512 to the box, and it worked.
>
> "SteveInBeloit" wrote:

Can't delete subscription

Hello,

I delete the publication, but the subscription still exists.

If I will delete the abonement I get following error 21776(Can't find Name xxx in the list of the TransPublications).

I tryed to craete the publication for the failed subscription again, but then I get the error, that a subscription for this publication still exists.

What can I do? How can I delete the subscription ?

Many thx for help!

Which SQL version are you using? Do you use scripts or UI to drop publication and subscription? Is subscription pull and located on the remote server? Could you please provide detailed repro step by step?

Thanks

Yunjing

|||

hello,

we use sql server 2000 and droped the replication via tsql

subscription is push and located on the remote server. I think I must delete all informations manuell in the server protocols, but how?

thx

Can't delete database that has been part of replication

I had a publication (merge) setup for a database. Deleted the publication and tried to delete the database. Sql server says it can't be deleted because it's has replication setup. Bug?

Found the answer. I had to run a stored procedure to get all replication objects removed from my db.

sp_removedbreplication @.dbname = 'dbname', @.type = 'merge'

/Magnus

Can't create Merge Publication

I have been trying for some time to create a Merge publication in SQL Server. I'm running SQL Server 2000 Standard Edition with the latest service pack on a Win2k3 Server. It doesn't seem to matter what replication-enabled database or which table I select
, I always get the same error at the end of the create publication wizard in Enterprise Mgr: "Error 2758 RAISERROR could not locate entry for error 21423 in sysmessages. Object 'pubs' (note: or whatever db I select) does not exist or is not a valid object
for this operation."
Any ideas here?
Corey - possibly this is an incomplete service pack install as some messages
in sysmessages are missing. You could have a look at sqlsp.log file from the
c:\windows directory which might shed some light on any failed actions
during the sp installation. Even if there isn't anything enlightening there
I'd reapply the sp3a.
HTH,
Paul Ibison
|||Thanks, Paul, but so far no luck. I dug through the log and didn't find anything all that revealing. I also re-applied SP3a, but that didn't help either. Still searching...
"Paul Ibison" wrote:

> Corey - possibly this is an incomplete service pack install as some messages
> in sysmessages are missing. You could have a look at sqlsp.log file from the
> c:\windows directory which might shed some light on any failed actions
> during the sp installation. Even if there isn't anything enlightening there
> I'd reapply the sp3a.
> HTH,
> Paul Ibison
>
>
|||Corey,
in htis case you could rebuild the master database or alternatively just add
the missing messages. To do the latter you'll need to create a linked server
to another server that has a complete master database and join to that table
(left outer join) to find the missing messages in sysmessages.
HTH,
Paul Ibison

Can't create a new publication

Hi,
I'm trying to create a publication in a SQL Server 2005 server. I
right clicked on Replication tab in management studio and selected
'New Publication'. The management studio waits for a long time and
then nothing happens. It does not start any 'New Publication' wizard
nor does it report any error. Could you please let me know if there
are any server settings that need to be enabled before configuring
Publications.
Thanks and Regards,
Thyagu.D
Does anything appear in the sql server log, or the windows log? What happens
if you run sp_adddistributor and sp_adddistributiondb directly?
Cheers,
Paul Ibison
|||You probably have some locking going on from a previous replication process.
Issue calls to sp_who2 or select * from sysprocesses where blocked<>0 order
by waittime desc to see if you can see these processes and kill them.
You might also want to try to create they publication by using replication
stored procedures.
Try sp_replicationdboption 'MyDatabase', 'published', true for a start.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Thyagu" <tdelli@.gmail.com> wrote in message
news:1184566869.270526.315190@.e16g2000pri.googlegr oups.com...
> Hi,
> I'm trying to create a publication in a SQL Server 2005 server. I
> right clicked on Replication tab in management studio and selected
> 'New Publication'. The management studio waits for a long time and
> then nothing happens. It does not start any 'New Publication' wizard
> nor does it report any error. Could you please let me know if there
> are any server settings that need to be enabled before configuring
> Publications.
> Thanks and Regards,
> Thyagu.D
>
|||On Jul 16, 2:14 pm, Paul Ibison <Paul.Ibi...@.Pygmalion.Com> wrote:
> Does anything appear in the sql server log, or the windows log? What happens
> if you run sp_adddistributor and sp_adddistributiondb directly?
> Cheers,
> Paul Ibison
This worked. Thanks!
Regards,
Thyagu.D