Thanks TDuffy - I am with you on both concerns.  A work around too, would be the use of temporary tables and DTS/BCP.  We use that on our site and...

Any performance enhancements needed?  I can see where potential "lag time" my take its toll on the environment.  Especially if working with VLDB's

Any thoughts?

Another thought: try Tracing your database.  There may be a run-on transaction that needs attending to.  Just a thought..

-Marti

I use this script:

declare @spid smallint, @k varchar(20), @@message varchar(255), @dbname varchar(10)

set @dbname = 'database_name'

if(@dbname is null) set @dbname = (select name from master..sysprocesses,master..sysdatabases where master..sysprocesses.dbid = master..sysdatabases.dbid...

Thanks Paul - I was suspicious of that.  And yes - I would like details, as I am most certainly going to be asked for them.  Even if you can...

Another thought (since we just went through this Painful process) is to budget a HUGE amount of space for this.  For example, our 150GB database had one table (that contained...

Recwin.exe sounds like an executable that belongs to a package from Checkfree Corporation's Recon Plus for Windows.  You may want to contact your Accounting Department, find out who the Administrator...

The recwin.exe - I am assuming that you have a software package from CheckFree Corporation called Recon for Windows - a reconciliation package and that executable sounds familiar.  You may want...

Is both MSSQLServer and MSSQLAgent set up with the same service account?  And did you log on to the server with this account to open Outlook?

Try that...just another idea!

-Marti

I agree - but there must be some way to monitor via sysobjects or somewhere - afterall - if embacedo can do it.... just was curious.

Thanks for the input!

-Marti