Hello,

I did create it on my local machine. I went in and created it on the server and it works perfectly now, don't know why I did not think...

Hello,

Thanks for your reply. I've tried to execute the package from within EM, the command prompt and within a job but I get the same error. However it...

Hello,

Thanks Phill for your reply. I've logged onto the server itself to verify that the server can see the DB2 database through ODBC, indeed it can.

Cheers,

Chris

Hello,

Thanks for that. I was hoping for something a little less drawn out where by perhaps I could change the PC name in the master db and or the...

Hello,

Well I do this a lot but soon after I posted the above request for assistance I figured out the issue. Thanks anyhow.

Cheers,

Chris Rutherford

Hello,

Thanks for your thoughts. I thought there would be some nice T-SQL to let me know when the table was last accessed without having to build up a history...

Hello there,

Sorry about this. It seems that every time I post here I figure out the answer a few minutes later no matter how long I've been trying to...

Hello,

Never mind I have figured it out. Thanks Steve for the point in the right direction.

Cheers,

Chris

Hello,

Well I've got a bit further but I'm still stuck. This is what I have...

select Login.Date,

Login.AgentName,

Login.Timestamp as 'Login',

(select timestamp from eagentloginstat where eventtype = 'LO' and agentname = login.agentname...

Oops, sorry, the computer kept prompting me to resend the information.

Chris

You don't have leading or trailing spaces by any chance do you??

select distinct ACCOUNTNO From ContSupp Where accountno not in

(

select distinct accountno from contsupp where ltrim(rtrim(rectype)) = ''E''

)

You could try...

You don't have leading or trailing spaces by any chance do you??

select distinct ACCOUNTNO From ContSupp Where accountno not in

(

select distinct accountno from contsupp where ltrim(rtrim(rectype)) = ''E''

)

You could try...

You don't have leading or trailing spaces by any chance do you??

select distinct ACCOUNTNO From ContSupp Where accountno not in

(

select distinct accountno from contsupp where ltrim(rtrim(rectype)) = ''E''

)

You could try...

Hello there.

Well this is how far I got...

select Login.Date,

Login.AgentName

from dbo.eAgentLoginStat as Login inner join dbo.eAgentLoginStat as Logout on

Login.AgentName...

Hello,

I've got this view in place at the moment...

SELECT Date,

AgentName,

(SELECT MIN(timestamp) FROM dbo.eagentloginstat

...