One failed subscription prevents running all others

Hello,
I was trying to invertigate why a certain report does not run properly in
some cases. I scheduled it to run daily. So far so good, i got logfiles to
study. However, since this try RS no longer executes ANY scheduled
subscription. i made no changes to the system, just scheduled a defective
report. (which BTW was in Excel and the row-count exceded 65536). Does
anybode know how to edit the (hypothetical) queue used by RS to clear the way
for my other subscriptions.
extra info: RSExecutionlog DB has no entries of executed subscriptions. The
SQL job manager says all jobs have executed succesfully as planned.(including
the subscriptions)Are there any rows in either the event table or notifications table?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ard Goossens" <ArdGoossens@.discussions.microsoft.com> wrote in message
news:175AE411-3994-4C8E-993F-8D4D258219B8@.microsoft.com...
> Hello,
> I was trying to invertigate why a certain report does not run properly in
> some cases. I scheduled it to run daily. So far so good, i got logfiles
> to
> study. However, since this try RS no longer executes ANY scheduled
> subscription. i made no changes to the system, just scheduled a defective
> report. (which BTW was in Excel and the row-count exceded 65536). Does
> anybode know how to edit the (hypothetical) queue used by RS to clear the
> way
> for my other subscriptions.
> extra info: RSExecutionlog DB has no entries of executed subscriptions.
> The
> SQL job manager says all jobs have executed succesfully as
> planned.(including
> the subscriptions)
>

Once replicated DB can't be detached

Dear Sir,
I have a database which has been "Transactional" replicated one table. I
already deleted the subscription and deleted the publication. But still the
database has the replicate icon besides on EM and not allowing me to detach.
What can I do to refresh the DB status in order to allow me to detach the db?
Many thanks!
Henry
Try this:
EXEC sp_dboption 'DBNameHere', 'published', 'false'
GO
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Henry" <Henry@.discussions.microsoft.com> wrote in message
news:9DB717B5-CCE8-41B8-A7CC-15E422F750E1@.microsoft.com...
Dear Sir,
I have a database which has been "Transactional" replicated one table. I
already deleted the subscription and deleted the publication. But still the
database has the replicate icon besides on EM and not allowing me to detach.
What can I do to refresh the DB status in order to allow me to detach the
db?
Many thanks!
Henry
|||Thanks!
"Narayana Vyas Kondreddi" wrote:

> Try this:
> EXEC sp_dboption 'DBNameHere', 'published', 'false'
> GO
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Henry" <Henry@.discussions.microsoft.com> wrote in message
> news:9DB717B5-CCE8-41B8-A7CC-15E422F750E1@.microsoft.com...
> Dear Sir,
> I have a database which has been "Transactional" replicated one table. I
> already deleted the subscription and deleted the publication. But still the
> database has the replicate icon besides on EM and not allowing me to detach.
> What can I do to refresh the DB status in order to allow me to detach the
> db?
> Many thanks!
> Henry
>
>

Once replicated DB can't be detached

Dear Sir,
I have a database which has been "Transactional" replicated one table. I
already deleted the subscription and deleted the publication. But still the
database has the replicate icon besides on EM and not allowing me to detach.
What can I do to refresh the DB status in order to allow me to detach the db
?
Many thanks!
HenryTry this:
EXEC sp_dboption 'DBNameHere', 'published', 'false'
GO
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Henry" <Henry@.discussions.microsoft.com> wrote in message
news:9DB717B5-CCE8-41B8-A7CC-15E422F750E1@.microsoft.com...
Dear Sir,
I have a database which has been "Transactional" replicated one table. I
already deleted the subscription and deleted the publication. But still the
database has the replicate icon besides on EM and not allowing me to detach.
What can I do to refresh the DB status in order to allow me to detach the
db?
Many thanks!
Henry|||Thanks!
"Narayana Vyas Kondreddi" wrote:

> Try this:
> EXEC sp_dboption 'DBNameHere', 'published', 'false'
> GO
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Henry" <Henry@.discussions.microsoft.com> wrote in message
> news:9DB717B5-CCE8-41B8-A7CC-15E422F750E1@.microsoft.com...
> Dear Sir,
> I have a database which has been "Transactional" replicated one table. I
> already deleted the subscription and deleted the publication. But still th
e
> database has the replicate icon besides on EM and not allowing me to detac
h.
> What can I do to refresh the DB status in order to allow me to detach the
> db?
> Many thanks!
> Henry
>
>sql

Once replicated DB can't be detached

Dear Sir,
I have a database which has been "Transactional" replicated one table. I
already deleted the subscription and deleted the publication. But still the
database has the replicate icon besides on EM and not allowing me to detach.
What can I do to refresh the DB status in order to allow me to detach the db?
Many thanks!
HenryTry this:
EXEC sp_dboption 'DBNameHere', 'published', 'false'
GO
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Henry" <Henry@.discussions.microsoft.com> wrote in message
news:9DB717B5-CCE8-41B8-A7CC-15E422F750E1@.microsoft.com...
Dear Sir,
I have a database which has been "Transactional" replicated one table. I
already deleted the subscription and deleted the publication. But still the
database has the replicate icon besides on EM and not allowing me to detach.
What can I do to refresh the DB status in order to allow me to detach the
db?
Many thanks!
Henry|||Thanks!
"Narayana Vyas Kondreddi" wrote:
> Try this:
> EXEC sp_dboption 'DBNameHere', 'published', 'false'
> GO
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Henry" <Henry@.discussions.microsoft.com> wrote in message
> news:9DB717B5-CCE8-41B8-A7CC-15E422F750E1@.microsoft.com...
> Dear Sir,
> I have a database which has been "Transactional" replicated one table. I
> already deleted the subscription and deleted the publication. But still the
> database has the replicate icon besides on EM and not allowing me to detach.
> What can I do to refresh the DB status in order to allow me to detach the
> db?
> Many thanks!
> Henry
>
>