Can't see a New Data Driven Subscription link

Hi:

I have SSRS 2005 standard but can't see the New Data Driven Subscription link so I am not sure how to create it! Please help..

Thanks.

As far as I am concerned the data driven subscription is an enterprise-only feature.

cheers,
Markus

Cant remove subscription info

Dear All,

I deleted a replication in the PROD server. However, the subscription info still exists in the subscription folder in the DR server.

Can anyone tells me how to remove the subscription info? (When I delete the publication, there's a message saying we need to manually delete the subscription info in the subscriber)

I'd tried restart the SQLAgent service, Disabling Publishing in PROD server but it's useless.

thanks first.

rgds.The subscriber may be not online when u dropped the publication.
Run sp_dropsubscriber at the publisher, see syntax in BOL. If it won't work; manually delete the subscription from the subscriber using Enterprise-Manager.|||Thanks TALAT.

However, the sp_dropsubscriber won't work, i keep hiting error 14048.

Anyway, my real interest is how to 'manually delete the subscription in EM' as mentioned by you...

Details:
At PROD server, publication is drop, there's NO item in Publications & Subscriptions Folder.

At DR server, there's no item in Publications Folder, BUT there's 1 item (subscription) in Subscriptions Folder.

Can you pls provide step-by-step details in how to delete the subscription info using EM?

thanks...|||Simply right click the subscription in the subscriber and choose delete. If u get error; run sp_mergesubscription_cleanup (if u r using merge replication) in the subscription db. It would clear all the subscription info.|||Thanks again TALAT,

Extra info: Previously I'm using Transactional Replication. At the Subscriber, in the Subscriptions Folder, it shows 1 item of subscription with the Type: Push

When I right-click on either the Subscriptions Folder or the Subscription itself, there's no Delete option to choose from, this is what bugging me.

Any idea?

Thanks first.|||http://support.microsoft.com/default.aspx?scid=kb;en-us;324401 to remove replication manually.|||Thanks Satya, the link is useful.

What's really bugging me is why there's no simple way to do this in EM?

rgds|||Sometimes its better to follow system supplied SPs rather than depending upon Lazy GUI tools, as far as my exp. conveys.

Can't pull the subscription

The process could not read file
'd:\sql_data\MSSQL\ReplData\unc\...\20050324084140 \snapshot.pre' due to OS
error 3.
What is going on?
Wack
This message will self destruct.
Looks like you set your snapshot folder to be a local path ("d:\...")
instead of a UNC path (\\mybox\d$\sql_data\MSSQL\ReplData). You specify the
default snapshot folder when you configure your publisher/distributor but
can override this value when you create a publication.
"Ray Lewis" <dav5489@.hotmail.com> wrote in message
news:enypHuHMFHA.3420@.tk2msftngp13.phx.gbl...
> The process could not read file
> 'd:\sql_data\MSSQL\ReplData\unc\...\20050324084140 \snapshot.pre' due to OS
> error 3.
> What is going on?
> --
> Wack
> --
> This message will self destruct.
>
|||The snapshots are going to the correct place, I.E, Server X = Distributor,
Server Y = Publisher, Server Z = Subscriber.
Server Y takes a snapshot of the db and stores it on Server X. Server Z,
however, can't get to the snapshot to replicate.
Wack
This message will self destruct.
"Mike Jansen" <mjansen_nntp@.mail.com> wrote in message
news:uJ4nJ7JMFHA.1300@.TK2MSFTNGP10.phx.gbl...
> Looks like you set your snapshot folder to be a local path ("d:\...")
> instead of a UNC path (\\mybox\d$\sql_data\MSSQL\ReplData). You specify
the[vbcol=seagreen]
> default snapshot folder when you configure your publisher/distributor but
> can override this value when you create a publication.
> "Ray Lewis" <dav5489@.hotmail.com> wrote in message
> news:enypHuHMFHA.3420@.tk2msftngp13.phx.gbl...
OS
>

can't modify stored proc which is in a publication

Hi

SQL 2005 sp1 - merge replication - HTTPS.

We have 2 publications for the database - one which has subscription.SyncType = SubscriptionSyncType.Automatic
and another with SyncType = SubscriptionSyncType.None.

The first publication is there so we can add new stored procs etc, the second contains the initial schema and the data.

When we try to modify a proc which is in the publication with SyncType = Automatic, the query never returns.

This is most urgent - thanks for your help.

Bruce

Do we have one or two subscriptions to publication one that contains the stored proc as a merge article in the publication?

|||

There are 2 subscriptions - one for each publication - but the proc is only in one publication

regards
Bruce

|||

1. Back to your original question - could the query (modifying the SP) be locked by another process so that it won't return?

2. Let us try to isolate this problem. If you can - colon the publication database, this publication (no second one), and subscribing database; does the same problem still occur?

Thanks.

|||

1. I doubt it..

2. 'colon the publication database' - what do you mean ?

thanks

|||

Create another publication database and create the same set of user tables/views/SPs. Just create one publication which includes the SP and other merge articles. See if you still can repro this issue with a single publication.

Thanks.

|||

We will try this tomorrow - but it's worth pointing out the following

a) the publication with SyncType = none -- has a few hundred stored procs - I can change any of these no worries

b) the publication with SyncType = automatic - initially just has 1 stored proc - so we can create the publication! - it's the procs we've added to this which we can't subsequently change.

Regards
Bruce

|||

Ok

I stripped it right back.

a. created a new database

b. added one proc

c. created the merge publication , snapshot etc

d. initalized ok

e. The query never returns....

Thanks
Bruce

|||

Can you share the proc prototype/definition (also I assume you use "ALTER PROCEDURE" to modify it)? I want to repro this case in house.

Thanks.

|||

Absolutely - it's a mindnumbing place-holder - it's just there so we can create the publication..

Don't laugh.

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

GO

--

-- This is the proc for the 'extras' subscription

--

--

ALTER PROCEDURE [dbo].[aaaaPlaceHolder]

AS

BEGIN

SET NOCOUNT ON;

SELECT 'fish', 'cow', 'dog', 'elephant', 'pig', 'moo', 's', 't', 'dog', 'sheep'

END

|||

Bruce,

Thanks for your help. I have repro-ed this scenario on my machine. I need to work with my peers to diagnoise the real cause of it. Should get back to you once I have the answer.

Regards,

Leo

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

As a temp solution - a dummy table can be created to join the SP in the same publication so that SP can be modified and replicated to the subscriber.

Leo

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi

I'll try it - has this been logged as a bug ? If so, how do I keep track of it ?

Thanks

|||

The bug was definitely filed and once I heard the decision/status I post it immediately.

Thanks

|||

This issue/bug should be addressed in Yukon Service Pack 2.

Leo

This posting is provided AS IS with no warranties, and confers no rights

can't modify stored proc which is in a publication

Hi

SQL 2005 sp1 - merge replication - HTTPS.

We have 2 publications for the database - one which has subscription.SyncType = SubscriptionSyncType.Automatic
and another with SyncType = SubscriptionSyncType.None.

The first publication is there so we can add new stored procs etc, the second contains the initial schema and the data.

When we try to modify a proc which is in the publication with SyncType = Automatic, the query never returns.

This is most urgent - thanks for your help.

Bruce

Do we have one or two subscriptions to publication one that contains the stored proc as a merge article in the publication?

|||

There are 2 subscriptions - one for each publication - but the proc is only in one publication

regards
Bruce

|||

1. Back to your original question - could the query (modifying the SP) be locked by another process so that it won't return?

2. Let us try to isolate this problem. If you can - colon the publication database, this publication (no second one), and subscribing database; does the same problem still occur?

Thanks.

|||

1. I doubt it..

2. 'colon the publication database' - what do you mean ?

thanks

|||

Create another publication database and create the same set of user tables/views/SPs. Just create one publication which includes the SP and other merge articles. See if you still can repro this issue with a single publication.

Thanks.

|||

We will try this tomorrow - but it's worth pointing out the following

a) the publication with SyncType = none -- has a few hundred stored procs - I can change any of these no worries

b) the publication with SyncType = automatic - initially just has 1 stored proc - so we can create the publication! - it's the procs we've added to this which we can't subsequently change.

Regards
Bruce

|||

Ok

I stripped it right back.

a. created a new database

b. added one proc

c. created the merge publication , snapshot etc

d. initalized ok

e. The query never returns....

Thanks
Bruce

|||

Can you share the proc prototype/definition (also I assume you use "ALTER PROCEDURE" to modify it)? I want to repro this case in house.

Thanks.

|||

Absolutely - it's a mindnumbing place-holder - it's just there so we can create the publication..

Don't laugh.

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

GO

--

-- This is the proc for the 'extras' subscription

--

--

ALTER PROCEDURE [dbo].[aaaaPlaceHolder]

AS

BEGIN

SET NOCOUNT ON;

SELECT 'fish', 'cow', 'dog', 'elephant', 'pig', 'moo', 's', 't', 'dog', 'sheep'

END

|||

Bruce,

Thanks for your help. I have repro-ed this scenario on my machine. I need to work with my peers to diagnoise the real cause of it. Should get back to you once I have the answer.

Regards,

Leo

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

As a temp solution - a dummy table can be created to join the SP in the same publication so that SP can be modified and replicated to the subscriber.

Leo

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi

I'll try it - has this been logged as a bug ? If so, how do I keep track of it ?

Thanks

|||

The bug was definitely filed and once I heard the decision/status I post it immediately.

Thanks

|||

This issue/bug should be addressed in Yukon Service Pack 2.

Leo

This posting is provided AS IS with no warranties, and confers no rights

Can't locate RS 2005 in MSDN library

I'm having trouble locating the RS 2005 install in the MSDN subscription
catalog. Can anyone tell me on which CD/DVD the install in located. I have
the SQL Server DVD. I can't seem to locate it when I search the online
subscription list either.
Thanks.If I put the unfiltered by as unfiltered and then look for reporting
services I find it.
Have you installed SQL Server Books On Line for SQL Server 2005? If you
don't see it in MSDN Library you will find it in Books On line SQL Server
2005
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"JW" <JW@.discussions.microsoft.com> wrote in message
news:9DF6DFF8-246B-4E82-9442-18F0F4E59D40@.microsoft.com...
> I'm having trouble locating the RS 2005 install in the MSDN subscription
> catalog. Can anyone tell me on which CD/DVD the install in located. I
> have
> the SQL Server DVD. I can't seem to locate it when I search the online
> subscription list either.
> Thanks.|||Sorry for the confusion. I'm looking for the install DVD in my MSDN
subscription. I was of the understanding that reporting services 2005 would
be in my December shipment but can't locate it. I also can't find it when I
search the subscription index here:
http://msdn.microsoft.com/subscriptions/index/default.aspx or in my online
subscription download.
"Bruce L-C [MVP]" wrote:
> If I put the unfiltered by as unfiltered and then look for reporting
> services I find it.
> Have you installed SQL Server Books On Line for SQL Server 2005? If you
> don't see it in MSDN Library you will find it in Books On line SQL Server
> 2005
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "JW" <JW@.discussions.microsoft.com> wrote in message
> news:9DF6DFF8-246B-4E82-9442-18F0F4E59D40@.microsoft.com...
> > I'm having trouble locating the RS 2005 install in the MSDN subscription
> > catalog. Can anyone tell me on which CD/DVD the install in located. I
> > have
> > the SQL Server DVD. I can't seem to locate it when I search the online
> > subscription list either.
> >
> > Thanks.
>
>|||RS does not have a separate DVD/CD. It is part of the SQL Server 2005
install. The only reason it did initially was that it was release mid cycle
for SQL Server.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"JW" <JW@.discussions.microsoft.com> wrote in message
news:B68EAD4B-993D-47AB-9721-DABC2A0ACCD0@.microsoft.com...
> Sorry for the confusion. I'm looking for the install DVD in my MSDN
> subscription. I was of the understanding that reporting services 2005
> would
> be in my December shipment but can't locate it. I also can't find it when
> I
> search the subscription index here:
> http://msdn.microsoft.com/subscriptions/index/default.aspx or in my online
> subscription download.
> "Bruce L-C [MVP]" wrote:
>> If I put the unfiltered by as unfiltered and then look for reporting
>> services I find it.
>> Have you installed SQL Server Books On Line for SQL Server 2005? If you
>> don't see it in MSDN Library you will find it in Books On line SQL Server
>> 2005
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "JW" <JW@.discussions.microsoft.com> wrote in message
>> news:9DF6DFF8-246B-4E82-9442-18F0F4E59D40@.microsoft.com...
>> > I'm having trouble locating the RS 2005 install in the MSDN
>> > subscription
>> > catalog. Can anyone tell me on which CD/DVD the install in located. I
>> > have
>> > the SQL Server DVD. I can't seem to locate it when I search the online
>> > subscription list either.
>> >
>> > Thanks.
>>