I am using linked server to get data and it seems to me the issue is there.

There aren't any connections in db and no other maintenence jobs running.

I see...

Link sql database tables into access and insert using access. Hope this may help.

Hi Teresa,

Actually C drive is for OS software and no rights were assigned to SQL agent on C. D drive is for App like SQL server and had rights on...

Check the path of script file directory under DTS import step.

I found the problem. Its with the rights on dts script file directory. The dts create script file under C:\Program Files\Microsoft SQL Server\80\Tools and agent doesn't have rights. Assigned rights...

There is no connection object in DTS. I given it try though and added connection to server SS2 and SS3 using windows authentication. but same error.

I tried changing owner of...

I have designed simple DTS as copy sql server objects task using DTS task. set up source and destination servers and used copy data - replace existing data for one...

Can anybody help with this issue or let me know which direction to look.

Yeah, the owner is sa. Checked agin. Also, tried with Co-domain/sqlserver (login for sql agent with sa permissions) but same error. No luck.

Thanks

This worked for me many times.

dbcc shrinkfile (2, notruncate)

dbcc shrinkfile (2, truncateonly)

create table t1 (char1 char(4000))

go

declare @i int

select @i=0

while(@i < 100)

begin

insert into t1 values ('a')

select @i = @i +1

end

truncate table...

Thanks for the advice .  The app is trapping errors due to multiple result sets. But it can be hacked if proper trapping is missing. I would like to consider...

Got it

Thanks for your help.

I already know without char(10) or next line or everything in one line get attacked. Is there way to break when char(10) is there?

The problem in not using dynamic SQL...

Thanks, You missed out char(10). see below

create PROCEDURE dbo.usp_GetContactValues

(

  @JobIDs nvarchar(4000)

)

AS

SET NOCOUNT ON

DECLARE @SQL nvarchar(4000)

SET @SQL = 'SELECT JOB_id, job_desc

  FROM JOBS WITH (NOLOCK)

  WHERE JOB_id IN ('...

Its the requirement of the complex nature of procedure.

If you see problem let me know how. I submitted my proc already. I have read almost every article on internet...