alzdba,

Thanks, the problem is that it runs perfectly from the package itself.  It even runs if I copy the dtsrun statement from the job and shell out to a command...

I'd just get it from sysprocesses.  sp_who2 would work as well. Use LastBatch or keep track of CPUTime.

Steve

I suppose you could set an "idle time" limit, and kill the spid when that limit is reached.  You could query sysprocesses to determine idle time and the spid.  It...

I would use backups/restores to move the databases, and possibly msdb for the DTS packages if there are quite a few.  Otherwise, I would save the DTS packages as vb...

Here's a little stored procedure I created from a script I found on SQLServerCentral ...

create procedure sp_MDAC

as

/*************************************************************/                                                                                                                                                     

--                                                  

-- Module Name: sp_MDAC

--                                               

-- Description:

-- The purpose of this procedure...

I just got through doing this as well, and ran into the problem that Sean describes.  My solution was to upgrade to 7.0 first, then to 2000.  Worked great.  I...

Thanks, Dana!

I hadn't seen that before.  I haven't read all the way through it yet, but it looks like a great "checklist" for diagnosing a DTS job.

Steve

Dana,

Thanks for the quick response!

I tried changing the job owner to sa, still failed.  It should be noted that the DTS package is running under the agent startup account regardless...

Load your output from the initial query into a temporary table.

Steve

bbron,

I'm assuming that your db is in full recovery mode.  I would suggest adding steps in between your sub-procs to do a transaction log backup.  That would help to keep...

Antares686,

I did not know that, thank you!!!

Steve

Here's the other one...

-- af_revLoginAttrib_2k

USE afDBA

-- Verify existence of sp_help_RevDBUsers procedure.  If it does exist,

-- drop it, so that it can be re-created.

if exists (select * from sysobjects where...

Ram,

I have written a series of stored procedures to script out security for a server so that it can be transferred.

If all you are concerned about is the logins (not...

To expand ever so slightly on Antares686's response -

In sysobjects,

xtype = 'u' is a user table

xtype = 's' is a system table

and sysobjects is a system table in each database...

The other really REALLY good resource is SQLServerCentral.com! Pour through the forums and read the questions and answers and learn!!!  Ask questions.  You'll get responses from some of the best!

Steve