Error 14222

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

Hello sir,

I want to drop a replication database 'production'. In Replication - Publishing, i uncheck in menu Publishing Databases 'production' and i receive this message: ->Error 14222:[SQL Server]Task 'encpc43_production'not found.

Afetr that, i create a task name 'production' with this commande: sp_addtask task_prod,CmdExec,encpc43,sa,production,1,64 when i execute this commande 'sp_helptask', i receive this : go -----------------------------*/ name id subsystem server username dbname enabled -------------------- ----------- --------------- -------------------- -------------------- -------------------- ------- Backup - production 6 TSQL (null) (null) production 1 task_prod 7 CmdExec encpc43 sa production 1

but the probleme 'error 14222' still existe.

Please advice me..

-- Anonymous, October 01, 1999

Answers

Tezniti,

You do not have to remove replication through the GUI. check out "Setting Up Replication Manually" in SQL Server Books Online and reverse the steps. Not only should this solve your problems but you will also learn a great deal about replication.

Or look at the Microsoft Knowledge Base article Q170481, titled, "INF: How to Manually Remove Replication".

Hope this helps,

Eric

-- Anonymous, October 01, 1999


Moderation questions? read the FAQ