"if the log files fill the available space on the drive. " ??? you do log backups right?

Right click the job in EM and choose ViewJobHistory

BOL

Optimizing Transaction Log Performance

General recommendations for creating transaction log files include:

• Create the transaction log on a physically separate disk or RAID (redundant...

better post your query and connection settings ...

BOL example 

BULK INSERT Northwind.dbo.[Order Details]   FROM 'f:\orders\lineitem.tbl'   WITH       (         FIELDTERMINATOR =...

DECLARE @ComponentInst TABLE(EventNumber int)

INSERT INTO @ComponentInst

SELECT 100 UNION ALL

SELECT 101 UNION ALL

SELECT 102 UNION ALL

SELECT 103

DECLARE @ComponentVal TABLE(

UniqueID bigint,

EventNumber int,

EventLabel varchar(20),

EventData varchar(100))

INSERT INTO @ComponentVal

SELECT 1, 100 ,'StartDate' ,'5/1/2006' UNION ALL

SELECT...

"thanks, that's what I thought except this idiot co-worker keeps whinning about how the scheduled portion of the job will still run even if the job itself...

I don t think the huge amount of time is not because your running it from DTS and not SP but by the amount of work to be done.

You ll...

I modified your query a lil since I don t have the target table for update

declare @doc int,@UpdBal varchar(1500)

set @UpdBal='<ROOT> <Upd CrAmt="0" DrAmt="785710.52" LID="1546" CID="BM" FYr="2006-2007"/>  <Upd CrAmt="785710.52" DrAmt="0" LID="2241"...

If you have a session/connection for each user that connects to your client app you could use

SET CONTEXT_INFO to store/retrieve information regarding your connection

Take a look at

xp_cmdshell / Data Transformation Services

alter Procedure SelFile

(

 @FileName char(50)

)

As

SET NOCOUNT ON

SET @FileName='E:\FileTransfers\Inputs\Emp\' +@FileName+' .txt'

BULK INSERT EmpInput FROM @FileName

GO

I eliminated the creation of temp table from inside the cursor BUT you ll receive beter input if you post the Tables that you have and what you want to...

SELECT glname,glacct,ap01,SUM(

CASE WHEN @AP>=1 THEN 1 ELSE 0 END * AP01+

CASE WHEN @AP>=2 THEN 1 ELSE 0 END * AP02+

CASE WHEN @AP>=3 THEN 1 ELSE 0 END * AP03+

CASE WHEN...

DECLARE @t TABLE(pos int, val int)

INSERT INTO @t

SELECT 1,10 UNION ALL

SELECT 2,20 UNION ALL

SELECT 3,30 UNION ALL

SELECT 4,40

SELECT A.pos ,SUM(B.val) as Total

FROM @t A INNER JOIN @t B

ON A.pos>=B.pos

GROUP...