So from that data, these are the records with the relevant datetime ??

00456633  2005-08-26 15:31:36  Completed    1125028938
00458176  2005-08-24 16:01:24   Resolved      1124856820
00461166  2005-09-15 13:15:11   Resolved     1126754120

What are you trying to do with this query? Looks like you're trying to update the field CaseResolvDatetime if there is only one record in the table.

Except that it requires a MAPI client and pre-defined profile.

Michelle, I've no idea why the email wouldn't have been received. Maybe a firewall/port mapping issue ??

Rudy, so you actually run the procedure on the remote server itself?

I've been thinking about doing something similar and using a DTS package to amalgamate the data on a central...

What other indexes are on the table? What indexes does the query use? Does the query use different indexes if you use ANSI standard joins in the FROM clause?

At first...

yes

For curiosity sake, how long did it take to run?

Hmmm ... that looks awful. I'm presuming this is not the change script generated in EM. Given that amount of output I'd be thinking that's more to do with the...

Michelle, Here's an example of what the job step could look like with xp_smtp_sendmail.

DECLARE @Subj varchar(100), @Msg varchar(8000), @Srvr varchar(100)

SET...

Michelle, you don't need IIS setup on the machine, that was just an example. All you need to provide is a valid smtp server as a parameter to the...

You can execute xp_readerrorlog for each of the remote servers. If you can use linked servers then you can use OPENQUERY. EG:

SELECT Qry.* FROM 
OPENQUERY(<<LINKED SERVER>>, 'SET FMTONLY OFF...

Ok, try this then,

-- Update CustPendCase to Y or N
UPDATE Asgn
SET Asgn.CustPendCase = CASE WHEN ISNULL(FlwUp.CallId, '') = '' THEN 'N' ELSE 'Y' END
FROM Asgnmnt Asgn
    LEFT...

Not quite sure from that post if you've got it worked out

And don't worry about being a...

Michelle, as I said in my earlier post I think you're unesscessarily complicating things by running a DTS package. Also, the sp_OA* procedures are know for there quirks and can...

Simple really, remove all the guff for the testing and you're left with the update statement. The update statement refers to a table variable that was created for testing, so...