Thanks Paul. I'll take an 'artifact of the measurement process' at this point. As long as this is not uncommon. I'll need to generate the same issue from a much...

Thanks for the advice. The question is not specifically related to this query. It's very complex and needs breaking down.

I'm just wondering how every thread can be waiting on CXPACKET...

Some points in this article no longer apply, some are mis-leading and some are just incorrect. Please read with caution.

Please ignore this thread. This is functioning correctly

Hi,

I thought that might be the reason. I knew (and understood) why it worked when using 'exists' but I thought it should fail when using 'in'.

Thanks

Jon

Yes. I am trying to change the model db owner to 'sa' but am unable to do so because you cannot change the owner of the model db. It's current owner has...

Hi,

Thanks for the response. Good to know that i'm not missing something obvious and it may be a bug.

Jon

Hi,

Thanks for the response. This does not work as you are not allowed to change the owner of the model database throught Management Studio or using sp_changedbowner.

Jon

I also have this problem. Server collation is Latin1_General Bin. Has anyone found a solution?

Thanks

Jon

I've alway moved tempdb and put all user databases on dedicated drives but until now i'd never considered moving the other system databases.

Cheers

Jon

Thanks for the responses. I think i'll move them as it's nice to have a bit of consistency.

Jon

Pete - you're a genius!

All I needed to do was set the "Delay Validation" property to "True".

I can now do the following:

1. I have 4 files in a folder named...

I am making some progress with implementing what I discribed in the first post. I'm stuck because of a bug with the Bulk Insert task not picking up variables at...

Thanks for that,

@error_flag does return an error code but so does @retval. I think it is a bug in sp_add_jobserver as it does not pick up the return value when calling...

sukhoi971,

I'm not new to SQL Server at all. I think you have misinterpreted my question. Nowhere did I ask how to run the agent service.