Can you provide a snippet of what the DTS package is supposed to do to help diag the problem?

You will need to have a registered unzip i.e. PKZIP, WinZip, etc...  You will also need a command-line editor (separate piece for WinZip).  You will then need to write VBScript...

Unfortunately, unless you are passing in the Environ$("COMPUTERNAME") in as a parameter and logging it to an audit table sp_who2 will only show the web server due to connection sharing....

I hate to ask this but, is there an index on OrderDate?

Another approach is to use Linked Servers (IF the database is on a different server)

OR you could do something like SELECT fields... FROM DBNAME.OWNER.OBJECT

In your INNER VIEW why can't you use SELECT TOP 100 PERCENT ... ORDER BY fieldx?

IF you set the DEFAULT to be GETDATE() this will ONLY be used on INSERT IF a date is not specified.

Hope this answers your question.

Should this: set @bag_nums = @bag_nums & @bag_num

Be

  set @bag_nums = @bag_nums + @bag_num

IF you are firing SPs have them 1st do an INSERT/UPDATE into the history table and THEN perform the request...

IF you are firing AD-HOC queries 1st perform HISTORY and THEN...

Is the PK IDENTITY set-up as IDENTITY = YES OR IDENTITY = YES (For Replication)??

Unfortunately, based on your information I would say YES.  The 1st T-LOG after your re-index would be VERY large (assumption is CLUSTERED INDEX re-orgs).

Go Frank!  Congratulations!

Below is how we do it.  A control file tells the VBS script which folders to examine

Dim filesys, metabackfolder, fil, filecoll, filist, ext, VFile, VerStr, intDaysOld

intDaysOld = 30

Set filesys =...

Basit, unfortunately, without seeing the code we cannot help much.  Can you please post the code for review?

PW,

I also use Textpad and it DOES highlight on screen but doesn't PRINT color. 

Andy,

I will give EditPad a try for printing in Color.  Thanks for the tip.....