Regarding weaponry:

Somewhere I used to work, we would mysteriously refer to "the debating sword", when preparing for battle with management

I think one of those would be handy in SSC, given...

I'm afraid I don't know

Here is a KB article that might help though:

http://support.microsoft.com/default.aspx?scid=kb;en-us;822318

http://www.liutilities.com/products/wintaskspro/processlibrary/vs7jit/

I'm guessing it's Visual Studio Just In Time compilation-related

Thanks Mohit.

Our set-up is a complete mess - an essay in bad practice!

At any rate, it seems to be running fine again now.

thanks for the clarifiation Matt

Thanks for your response Mohit

Our databases are not at all large - 10000 rows in the bigger tables, maybe

...

Thanks.

So there is one plan cache per...

Right - the server had to be rebooted in the end, as shutting down the service didnt run cleanly.

We're up and running normally now. All I can see in the...

Thanks for your time Roy.

The service is being restarted now.

A colleague dropped a database earlier this morning (without any problems as far as he could tell), but for some reason...

Thanks Roy

2GB RAM on the server - I'm not sure where to...

I'm only round the corner from it in Leeds, so nice and easy for me (although with...

Congrats!

I've been trying to gear myself towards buckling down and studying for it, but it ain't working! I'm taking a month-long holiday in May,...

I don't know about 2008, but the brackets definitely get highlighted in 2005 - just for an instant when you're typing the closing bracket

Yes, that was indeed the problem.

Of course, now that I've figured it out I feel like it's been staring me right in the face all day...

I think I know what's going on.

I haven't dealt with Sql2000/DTS for a while now, and had forgotten that DTS keeps previous versions of msdb packages

So the DtsRun commands within...