Re: problem running sp_addpublication
- From: "Paul Ibison" <Paul.Ibison@xxxxxxxxxxxxx>
- Date: Mon, 24 Oct 2005 20:12:06 +0100
Adam,
I suggest running profiler to see what are the parameters being sent to this
procedure and to debug where the process is going wrong. The most likely
cause is a changed servername, as the error is raised in several system
procedures and the code is usually of the form....
select @distribution_jobid = job_id from msdb..sysjobs_view where
name = @name and
UPPER(originating_server) = UPPER(CONVERT(sysname,
SERVERPROPERTY('ServerName')))
if @distribution_jobid IS NULL
begin
-- Message from msdb.dbo.sp_verify_job_identifiers
RAISERROR(14262, -1, -1, 'Job', @name)
GOTO UNDO
end
So, if your servername has changed, this could be the cause of the problem.
In this case:
Use Master
go
Select @@Servername
This should return your current server name but if it
returns NULL then try:
Use Master
go
Sp_DropServer 'OldName'
GO
Use Master
go
Sp_Addserver 'NewName', 'local'
GO
Stop and Start SQL Services
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
.
- Prev by Date: Re: can't delete a row?
- Next by Date: Re: can't delete a row?
- Previous by thread: Need Feedback on Trans. Replication w/ Remote Distributor
- Next by thread: Replication Consultants
- Index(es):
Relevant Pages
|
