July 22, 2005 at 12:13 pm
I was just experimenting with something in replication and created a test database called "ReplicationTest"
This is on a server that is currently a subscriber for other databases, but I thought I'd also be able to set up a publication from "ReplicationTest" Db.
I tried to create a publication and got the error:
Error 14294 supply either @Job_id or @Job_name to identify the job.
What does that mean ??
So I said "to heck with it" (or something like that) and decided to just delete ReplicationTest database since I got stuck & had real work to do and no publication had been created. But now it won't let me delete ReplicationTest database because it says it's being used for replication ......... So, what should I try ?
July 22, 2005 at 1:56 pm
Check sp_dboption. If either 'merge publish' or 'published' are turned on, turn them off and give it another try.
July 22, 2005 at 2:26 pm
You were right on the money .... Thanks !
I'm still puzzled by the error, but I guess I won't worry about that until I really need to.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply