Re: Unable to create dynamic snapshot job

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

SQL Server 2000 SP4, my apologies, forgot to mention that.

"Hilary Cotter" <hilary.cotter@xxxxxxxxx> wrote in message
news:ec7bf6wyGHA.3440@xxxxxxxxxxxxxxxxxxxxxxx
These are SQL 2005 specific. What version are you running again?

--
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



"footyplayer" <anonymous@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:%23f0A%23rwyGHA.772@xxxxxxxxxxxxxxxxxxxxxxx
Hi Hilary,

I tried all of these, and I couldn't find any information in BOL or
online about these, so I assume they don't exist or I need to install
something I currently don't have. Are these procedures only included in
the resource kit or something?

Thanks
Brad

"Hilary Cotter" <hilary.cotter@xxxxxxxxx> wrote in message
news:eLdNZMRyGHA.3568@xxxxxxxxxxxxxxxxxxxxxxx
have you tried

sp_dropdynamicsnapshot_job
sp_MSdrop_dynamic_snapshot_agent
sp_MSdropmergedynamicsnapshotjob


--
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



"footyplayer" <anonymous@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:uyv7eVHyGHA.4524@xxxxxxxxxxxxxxxxxxxxxxx
Hi All,

I am trying to re-create a dynamic snapshot job we once had on our
server using the same name, however I am unable to do so. The old
dynamic snapshot job has been dropped, but even after running the
replication cleanup jobs, I am unable to re-use the name. Upon further
investigation, I found that the job name still exists in the
MSdynamicsnapshotjobs table. Is there a stored procedure I can run to
'clean up' the data in that table, or can I safely delete the row? Any
assistance is greatly appreciated!

Best Regards,
Brad









.

Relevant Pages

  • Re: SQL2005 FT error adding table column
    ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... When I click on "Columns" in the FT Index Properties pane, ... Microsoft SQL Server Management Studio ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Search Design
    ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... Looking for a SQL Server replication book? ... You will also get better performance by dedicating a catalog to each ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Creation of Indexes on the subscriber database
    ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... Looking for a SQL Server replication book? ... "Hilary Cotter" wrote: ...
    (microsoft.public.sqlserver.replication)
  • Re: Transactional Replication 2005
    ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... Looking for a SQL Server replication book? ... subscriber b and then use subscriber B as a publisher to subscriber c. ...
    (microsoft.public.sqlserver.replication)
  • Re: SQL2005 FT error adding table column
    ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... Microsoft SQL Server Management Studio ...
    (microsoft.public.sqlserver.fulltext)