USE msdb

EXEC sp_help_job

This should do.

Paul Ibison PhD, MCSD

email: Paul.Ibison@btinternet.com

Thanks Patilds - didn't bother to ckeck the knowledge base because it seemed such a fundamental bug - assumed I'd done something wrong. Checked out your KB article and there...

Sorry - not very clear but the message was the thread name : 'Unable to browse the cube 'Budget'. '

Paul Ibison PhD, MCSD

email: Paul.Ibison@btinternet.com

I've had this error with excel files when the source or destination file was already open.

Paul Ibison PhD, MCSD

email: Paul.Ibison@btinternet.com

Thanks guys - I believe I've sussed it. I did a profile which traced almost all objects and events and when the database went slow this...

Have tried using QA over the last couple of days and unfortunately it also hangs for 30 seconds or so. In terminal server I am able to monitor the activity...

thanks Andy, your solution works well. I was using the SQL 7 EM to try to do the same and it was disallowed, so I didn't think of direct stored...

We don't use them and will be implementing our own solution, so I'd like to do a clear out.

Paul Ibison PhD, MCSD

email: Paul.Ibison@btinternet.com

Thanks Steven - actually I did leave EM running on the server. However, the situation righted itself with EM still there.

Unfortunately this is a sporadic problem and although I have...

Reply to my own question - just in case someone else had a similar issue.

Solution is use select cast(@mydec as varchar(12)) as MyField, and 0.00 mysteriously appears.

Thanks for all your help, advice, encouragement etc. I'm happy to say that I did the exam last week and passed first time with a score of 877. This is...