A covering index is one used to satisfy more than one query efficiently say searching by name or cost,  as opposed to creating a specific index for each separate query.

To truly create an accurate covering index one needs to have more than one query to accomodate ! Based on the question, the covering index with or without the 'include'...

Try this procinstead - sp_MSdependencies

NIMDB

Simple statements for the situation (it really is a very simple situation).

I would expect to be charged <period>. Granted a mistake was made, but you never get something for nothing....

A big "thumbs up" to you Steve ! Thanks !

It was 'free choice' and moral conviction that made this possible.

Now think for a minute about rights and freedom in relation to women. Next let's take into account time and quantify...

Steve,

Colin was speaking plainly as would I. This is not wrong it is an opinion. These things are a part of our respective careers and lives. Remember the columns about...

SQL Server errorlog(s) anyone ?

Just as a test, why not add PRINT @CMD instead of the EXEC statement. The cut the output line out and paste it into a DOS window and see of the...

MOM 2005 supports SQL 2000 and SQL 2005.

Don't forget to set your database context to the proper database prior to running the select. If you do not, then you can get an incorrect object name or NULL...

Just a few more diagnostic questions to ask:

• Is there any application software installed on the server ?
• Has any new software been added ?
• Has any new existing software been updated ?
• Has anyone...

If you are using MOM 2005 the SQL Server Management Pack has alerts for just this and a number of other relevant SQL monitoring criteria.

I agree with mvee on the headers issue. The previous version of the newsletter made those relevant areas stand out a bit more. Quite possibly you could increase the font...