 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Replication / August 2006Unable to create dynamic snapshot job
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 have you tried sp_dropdynamicsnapshot_job sp_MSdrop_dynamic_snapshot_agent sp_MSdropmergedynamicsnapshotjob  SignatureHilary 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 > Hi All, > [quoted text clipped - 9 lines] > Best Regards, > Brad 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 > have you tried > [quoted text clipped - 15 lines] >> Best Regards, >> Brad SignatureHilary 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 > Hi Hilary, > [quoted text clipped - 25 lines] >>> Best Regards, >>> Brad These are SQL 2005 specific. What version are you running again? SignatureHilary 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 > Hi Hilary, > [quoted text clipped - 25 lines] >>> Best Regards, >>> Brad SQL Server 2000 SP4, my apologies, forgot to mention that. > These are SQL 2005 specific. What version are you running again? > [quoted text clipped - 27 lines] >>>> Best Regards, >>>> Brad |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.