Cool question that introduced me to this feature. Thanks

Individual job steps can not be disabled or enabled.

You can run sp_update_jobstep on the step preceeding the one you want disabled and change its @on_success_action  and or @on_success_step_id...

In 2005, on certain OS, instant file initialization is possible when configured correctly.

Instant File Initialization

In SQL Server 2005, data files can be initialized instantaneously. This allows for fast...

I am not sure about this discrepancy, but there are issues, errors, and discrepancies in MS docs. Example below.

The BOL from April 06 shows no processor limit for standard...

Yes the problem was resolved with the hot fix.

Terry

I know the song and dance about how difficult it is to put out a question but...

When the answer "In the Object Explorer, under the "Server Objects" folder is...

I don't beleive it, have never seen it, and trust BOL before any blogs.

Terry

Me too!

Terry

Cool question. Even though I could get the answer by examining BOL and the file, it forced me to examine the file and learn more about how it works.

Thanks

Apparently this behavior is not new with SQL2005. I performed testing with SQL2000, and the optimizer encounters the same DBCC Show_Statistics failure on the linked...

Thanks for the help Colin, and the friendly words.

Terry

The distribution agent (and all replication agents) runs as an agent job. If you have sql mail configured, set the job to notify you on failure....

Accoring to Books on Line, Tracer Tokens measure three things, not two.

View elapsed time for the tracer token in the following columns: Publisher to Distributor, Distributor to Subscriber, Total Latency....

We use MOM, but its alerting system leaves much to be desired. I have resorted to loading MOM alerts to a separate database table, and sending my pages/emails from that...

We also had a restart problem, and none of the prior ideas worked. It seems that Terminal Server was causing a reduction in the working set size in all windows...