Everything that has been said thus far indicates that Perfmon counters can be used at a later date, to see what has already happened on a server.

Is it possible for...

Thanks for all the advice, I have managed to get hold of a workstation that I can use as my monitoring 'server', so I shall have a play.

One thing I...

Hi,

Sorry, I should have updated this yesterday but didn't around to it.

When I investigated further I found that the size for that column in the target dimension, as specified...

For further information - The SSAS package has not changed for a very long time (and has been happily working for ages).

No changes have been made to the tables.

Any ideas?

Thanks for that Lowell.

I have added the SELECT STMT to the SP.

I shall check it again tomorrow am to see what it gives me.

P.S. It didn't like the 'ORIGINAL_LOGIN() AS...

Hi,

Yes, I tried amending the SP to query the sys.dm_exec_connections DMV as suggested in the reply by Lowell!!

When the stored procedure failed to run this morning, I started investigating why...

Hi All,

I have made a massive blunder here.

I have posted this query in the wrong forum.

My instance is a SQL Server 2000 instance NOT 2005.

Sorry.

With this in mind, which of...

Thanks for the reply Dave.

I have checked dbo.sysjobsteps where command contains the SP name, but I'm not getting any results back.

So if it is not an SQL Agent job, where...