Nope, I confirmed, no jobs are set to start when sql agent starts.

I think I will try changing the account that sql agent runs under although I don't think that's...

Here is one. thanks

Never mind. I found the answer immediately after posting my message.

DBCC USEROPTIONS

thanks

Excellent article. It's very readable with good examples.

So just curious, does that auger get power from the power takeoff or does it have its own engine and just attaches to the tractor? Looks like a great...

Thanks for this info! It just helped me out too

I have been using your script and it works great but I found one "opportunity". I found that the script would always execute a REORGANIZE and never a REBUILD....

Lennart, you can ignore the question I posted earlier today. Apparently I caused those errors. My DBs are mirrored and must stay in Full recovery model. So...

Hi Lennart,

I am trying to use your script. The SPs create just fine but when I try to execute spX_RebuildIndexes_Main I am getting invalid column errors. I thought...

Excellent. This will be very useful.

Today I set up 2005 log shipping for the first time and I have the same behavior.

In addition, although my copies and restores seem to be working, the...

2000 and 2005 can definitely coexist, but here's one caution.  I had 2000 (developer edition) on my laptop.  I installed the 2005 evaluation edtion and everything worked fine.  Then I...

I still haven't figured it out.  I have now uninstalled the evaluation edition and installed the standard 2005 edition.  I still get the same error.  Since the error seems to...

Assuming you mean service pack 1, the bug fix list is at http://support.microsoft.com/kb/913090/.  New features and improvements is at http://support.microsoft.com/kb/916940/.

I'm with you.  I know that if you download & install 2005 Express, you don't get the tools.  I guess with the developer edition you don't automatically get the tools...