Yes Sir,

create PROCEDURE dbo.spjobbegin AS

BEGIN

 DECLARE @jobId VARCHAR(36),

 DECLARE @jobTotal INT

 SET @Jobtotal = 0

 SELECT @JobTotal = count(*) FROM db_one.dbo.job_tbl

  WHERE jobID = @jobID

 UPDATE db_one.dbo.job_tbl SET jobTotal=@jobTotal

  WHERE jobID = @jobID

 IF @jobTotal >...

Thanks Frank

BTW: The store procedure is not using dynamic query

Nita

No its not helping, the website is in some other language.

Steve,

dbo is the owner of the table. And all the store procedure is to own by dbo.

But I give just execute permission it say denied on insert and update on...

Thanks Also

Also I am having issue with replication how to do restore replication on another server, we are using transactional repl.

Thanks

N...