Delete an old subscription from the subscriber?

The publisher has been disabled. But on the subscriber, I'm unable to delete
the subscription. It was a merge.
I tried to use sp_dropmergesubscription, but I've been unable to find a good
syntax example. And from which place do I run it?
Thanks in advance for any help.
Leah
If this is SQL 2000 use the following script.
http://groups.google.com/group/micro...d?dmode=source
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
"Leah" <tech@.kaplooey.com> wrote in message
news:O9LBJo2GGHA.2444@.TK2MSFTNGP11.phx.gbl...
> The publisher has been disabled. But on the subscriber, I'm unable to
> delete the subscription. It was a merge.
> I tried to use sp_dropmergesubscription, but I've been unable to find a
> good syntax example. And from which place do I run it?
>
> Thanks in advance for any help.
>
> Leah
>
|||I ran the script in both places. didn't get rifd of the subscription. In the
meantime, I'm trying to re-establish merge replication, and now I get the
cant find sp_MSupdate_replication_status in the master table. Where is this
script located, so I can reinstall it?
Thanks for your help.
Leah
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OQn9ot3GGHA.3728@.tk2msftngp13.phx.gbl...
> If this is SQL 2000 use the following script.
> http://groups.google.com/group/micro...d?dmode=source
> --
> 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
> "Leah" <tech@.kaplooey.com> wrote in message
> news:O9LBJo2GGHA.2444@.TK2MSFTNGP11.phx.gbl...
>
|||Okay - I found a source for the scripts.
http://www.webtropy.com/articles/sql...cedure.asp?SQL
I'm still trying to remove the old subscription from the subscriber.
"Leah" <tech@.kaplooey.com> wrote in message
news:eVK6y5DHGHA.984@.tk2msftngp13.phx.gbl...
>I ran the script in both places. didn't get rifd of the subscription. In
>the meantime, I'm trying to re-establish merge replication, and now I get
>the cant find sp_MSupdate_replication_status in the master table. Where is
>this script located, so I can reinstall it?
> Thanks for your help.
>
> Leah
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:OQn9ot3GGHA.3728@.tk2msftngp13.phx.gbl...
>
|||http://www.replicationanswers.com/General.asp had it:
L.
"Leah" <tech@.kaplooey.com> wrote in message
news:O9LBJo2GGHA.2444@.TK2MSFTNGP11.phx.gbl...
> The publisher has been disabled. But on the subscriber, I'm unable to
> delete the subscription. It was a merge.
> I tried to use sp_dropmergesubscription, but I've been unable to find a
> good syntax example. And from which place do I run it?
>
> Thanks in advance for any help.
>
> Leah
>

Delete a subscription but constrains created for auto-identity remains

Hello,
I've a merge replication in SQL Server 2000 with one publication, where all
the articles are tables. Some of these tables have IDENTITYs and I've
choised SQL Server auto identity range.
When I delete a subscription all replication tables and information related
to the replication is deleted in the Subscriber, but the constraints created
for the identity's management (something like
'repl_identity_range_sub_9DD926BD_FEC3_443C_850B_B 02538F2D06A') still exists
(in the Subscriber).
I'm not sure if I'm doing something wrong or if I've to create a script to
drop all these constraints. Does someone know about it?
Thank you in advance,
Josep.
I have reported this problem to Microsoft. You have to write a script to
remove it.
"Josep" <jmartinez@.autec.es> wrote in message
news:eeO1YXdgHHA.1216@.TK2MSFTNGP03.phx.gbl...
> Hello,
> I've a merge replication in SQL Server 2000 with one publication, where
> all the articles are tables. Some of these tables have IDENTITYs and I've
> choised SQL Server auto identity range.
> When I delete a subscription all replication tables and information
> related to the replication is deleted in the Subscriber, but the
> constraints created for the identity's management (something like
> 'repl_identity_range_sub_9DD926BD_FEC3_443C_850B_B 02538F2D06A') still
> exists (in the Subscriber).
> I'm not sure if I'm doing something wrong or if I've to create a script to
> drop all these constraints. Does someone know about it?
>
> Thank you in advance,
> Josep.
>
|||Thank you Hilary for your help !!
I have wrote the script. I post it here in case someone is interested in it:
/*
This script drops all CONSTRAINTs created by Merge Replication to manage
automaticaly the range of IDENTITYs,
due to SQL Server don't drop them when you delete the subscription in a
Subscriber.
*/
-- It should be executed on the replicated database
DECLARE @.table NVARCHAR(2000), @.constraint NVARCHAR(2000), @.sql
NVARCHAR(2000)
-- We get all the CONSTRAINTS used by automatic IDENTITY range
SELECT
table_name, constraint_name
INTO #IdentityConstraints
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
WHERE CONSTRAINT_NAME LIKE 'repl_identity_range_sub_%'
-- We DROP these CONSTRAINTs
WHILE (SELECT COUNT(*) FROM #IdentityConstraints)>0
BEGIN
SELECT TOP 1 @.table=table_name, @.constraint=constraint_name FROM
#IdentityConstraints
SET @.sql = N'ALTER TABLE ' + @.table + ' DROP CONSTRAINT ' + @.constraint
EXEC sp_executesql @.sql
PRINT 'Dropped CONSTRAINT "' + @.constraint + '" in table "' + @.table + '"'
-- Once dropped the constraint selected, we delete it in the temporary
table
DELETE FROM #IdentityConstraints WHERE constraint_name=@.constraint
END
"Hilary Cotter" <hilary.cotter@.gmail.com> escribi en el mensaje
news:u16RYadgHHA.4952@.TK2MSFTNGP02.phx.gbl...
>I have reported this problem to Microsoft. You have to write a script to
>remove it.
> "Josep" <jmartinez@.autec.es> wrote in message
> news:eeO1YXdgHHA.1216@.TK2MSFTNGP03.phx.gbl...
>

Delete a subscription

It may be simple but I find it difficult to delete a subscription. When I
right click the subscription I don't get this option and I can only delete
it by deleting the Publication
If this is SQL 2005, go to the subscriber and delete it from the local
subscriptions folder.
You should also be able to expand the publication on the publishers folder
so that you can see the subscriptions, right click on it there and select
delete.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"Samuel Shulman" <samuel.shulman@.ntlworld.com> wrote in message
news:OyUYiqi4GHA.1460@.TK2MSFTNGP05.phx.gbl...
> It may be simple but I find it difficult to delete a subscription. When I
> right click the subscription I don't get this option and I can only delete
> it by deleting the Publication
>
|||Thank you,
I use SQL Server 2000
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:eAHRq3i4GHA.4256@.TK2MSFTNGP03.phx.gbl...
> If this is SQL 2005, go to the subscriber and delete it from the local
> subscriptions folder.
> You should also be able to expand the publication on the publishers folder
> so that you can see the subscriptions, right click on it there and select
> delete.
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> 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
>
> "Samuel Shulman" <samuel.shulman@.ntlworld.com> wrote in message
> news:OyUYiqi4GHA.1460@.TK2MSFTNGP05.phx.gbl...
>
|||Right click on the publication, select properties, click on the
subscriptions tab, and delete it there.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"Samuel Shulman" <samuel.shulman@.ntlworld.com> wrote in message
news:eq3QUKn4GHA.3736@.TK2MSFTNGP02.phx.gbl...
> Thank you,
> I use SQL Server 2000
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:eAHRq3i4GHA.4256@.TK2MSFTNGP03.phx.gbl...
>
|||Thank you but it doesn't appear on that list
Any suggestions why?
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:u5kopMq4GHA.2264@.TK2MSFTNGP02.phx.gbl...
> Right click on the publication, select properties, click on the
> subscriptions tab, and delete it there.
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> 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
>
> "Samuel Shulman" <samuel.shulman@.ntlworld.com> wrote in message
> news:eq3QUKn4GHA.3736@.TK2MSFTNGP02.phx.gbl...
>
|||Is this 2000 or 2005?
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"Samuel Shulman" <samuel.shulman@.ntlworld.com> wrote in message
news:uyNRgCx4GHA.4832@.TK2MSFTNGP06.phx.gbl...
> Thank you but it doesn't appear on that list
> Any suggestions why?
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:u5kopMq4GHA.2264@.TK2MSFTNGP02.phx.gbl...
>
|||2000
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:u4oykx24GHA.3736@.TK2MSFTNGP02.phx.gbl...
> Is this 2000 or 2005?
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> 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
>
> "Samuel Shulman" <samuel.shulman@.ntlworld.com> wrote in message
> news:uyNRgCx4GHA.4832@.TK2MSFTNGP06.phx.gbl...
>

Default rendering in a subscription

Hi all,
I have uswers who are setting up their own subscriptions and I have been
asked if we can change the default rendering option. It is currently set to
web archive and we almost always use PDF. I haven't been able to find a
setting that will change this. Any ideas?
ThanksHi clang,
Thank you for your post!
When you create a subscription in the report manager, you could configure
the render format.
There is an option named Render Format and you could set the format there.
The PDF file is in the list.
Here is an article for your reference:
Choosing Report Presentation Formats in a Subscription
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rswork/htm/
rms_subscribing_v1_9c6p.asp
How to Specify a Format
If you are specifying the delivery through Report Manager, you can choose
the format from a drop-down list. If you are specifying a delivery
programmatically or through a query (as supported by data-driven
subscriptions), use the text strings as defined in the
rsreportserver.config file. The rendering extension names in the
configuration file vary slightly from the rendering formats displayed in
Report Manager. For example, TIFF in Report Manager is equivalent to IMAGE
in the configuration file.
Hope this will be helpful!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.