Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vkclass
Starting Member
1 Post |
 Posted - 2007-03-06 : 17:40:39
|
| I have a case of SQL Server 2005 production db's publication which does not have either Log reader, snapshot or distribution agents.I need to modify primary key in one of the tables, and existing publication does not allow this.When I try to start snapshot job in GUI I am getting of course error:"Could not find the regular snapshot job for the spicified publication. Supply either @job_id or @job_name to identify the job, error 20678."Is there any way to erase it with system st procs or SQL?Help is greatly appreciated. |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-03-08 : 17:02:27
|
| i haven't encountered your case yet (sounds serious, some leftover or uncommitted publication creation) but in 2000 there's a clean up system sproc, search msdn for the equivalent in 2005 (i remember searching for it once, 2 years back and found it at msdn)HTH--------------------keeping it simple... |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-03-08 : 17:06:35
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=78724--------------------keeping it simple... |
|
|
|
MohammedU
Posting Yak Master
145 Posts |
|
|
|
|
|
Deleting publication with no Agents available