I suggested doing just that, but since the scheduled jobs are created by a third-party software package, they don't want the scheduled jobs altered since the changes may disappear during...

How do you script the trace?  I think I am doing something wrong.  I build the trace, start it and then select File - Script Trace - SQL Server 2000. ...

DB,

I've read all the BOL info.  From what I understand you still need to configure a profile regardless of whether it's SQL Mail or SQL Agent Mail.  They don't need to...

I just looked at properties again and it lists SQL Server Standard Edition.  Under the memory tab is listed 3712 as the maximum memory, but the max memory configuration setting...

Thanks Terry for the confirmation.

Dave

I like that approach.  I'll see if the rest of our DBA team would like to pursue this option.  Is there anything I need to be made aware of such...

We'll probably deny access to these procedures. I find it strange that xp_sendmail can only be executed by DBOs and sysadmins, yet DTS packages can be created by anyone....

Thanks Steve.  We'll look into it. 

On a somewhat related note, do you know how to restrict permissions with DTS so only specific people have the ability to create packages? ...

One last follow-up question to 5 & 6. If running in Simple recovery mode, would the checkpoint move the data directly to the database or would it first be...

Thanks for the help. In my Delete statement above, at what point will the 100,000 records be sent to the T-Log? I assume after the first "GO" the...

I'll look into your ActiveX recommendation. Any tips on you to handle DTS code migration from Test to Production? I'm hoping there is a way to avoid having...

It's a combination of transformations and sql queries, inserts and updates. I did some more research and assuming I understand things correctly, SQL Server automatically tries to execute DTS...

I noticed the "For Internal Use Only", but wasn't sure what it meant. Since Job_Name was being offered as a parameter I thought it was valid for me to...

Thanks for the suggestions.

Dave

Greg,

Using SQL Server scheduler is one option I have considered for a more long-term solution, but since we have over 100 scheduled jobs, it will take some time to convert...