The login account is the same for both SQL Server and SQL Server agent.

Thanks Steve.  The entries are being written to the Windows Event Log.  I checked out Database Daily but couldn't find anything that referred specifically to my situation.

Thanks Gary!!!.  That did the trick.

It might work a little differently in Word 2002.  For others that might want to make this modification, you need to take one more step.

Thanks AJ!!

While that certainly does work, I was hoping to avoid that extra step.  I really don't have any need to save a version of the Word document in a...

ThomasH,

It might be a different sql session, but it probably wouldn't be over a long time period.  It would only be for purposes of further querying the result set.  Essentially,...

Frank,

Thanks, but I was initially using a temporary table.  The problem is that the users want their result set to be accessible for querying after the session ends.  I guess...

Jonathan,

Thanks for your reply.  I realize that it would be preferable to use a report writer to do the job, but I would like to try your method.  We have...

Thanks to jxflagg and David for your replies. I tried jx's method and that seemed to do the trick. However, I'm sure that David's join method would also...

Thanks. I am basically doing just that, importing all new zip code records into a temporary staging table. One table, ZIP_CODE_IMPORT contains the following fields: ID (UniqueID), ZipCode,...