I think that you backed up to 2 files somehow in this case. If you had two files listed in the backup dialog, even if one was selected, the backup...

Can you provide the insert statement and the exact message?

RedGate has one as well. Both it and the Apex tools are highly rated.

You will need to experiment for a few things and go from there. SOUNDEX can help as well.

I would first look to remove common things instead of matching up. So...

Possibly during a clustered index delection the row count was not available, but I've never heard of any data being lost during the optmization jobs.

You can also set an alert on a performance counter. In this case, the disk space on a particular drive.

I don't think there is such a switch either. I would beware of the features that are listed as not working in Standard, but most of the "functionality" should be...

In 7 and prior versions it would log the event when you exceeded connections, but I don't think it stopped anyone from connecting. Not sure about 2000/2005

Thanks for the opinions and they are definitely interesting. It seems that this is something MS will push a little to save companies some money as well as sell some...

Paying for work to be done for you is not wrong. The idea behind Rent A Coder is great.

However turning this work in to a professor is misrepresenting it. You...

I think posts are a grey area. If you post substantial code or develop original thoughts in a paragraph or two, then I think your words are copyrighted. Quoting someone...

I have corrected the answers as it is indeed 2^31 - 1 characters. Sorry, missed that little subtraction late last night.

I got to two pages, and start to drop things when I get longer. The other thing I do is reduce the amount of description in older jobs, so the...

Ian,

You can reduce this by limiting the results again to look for a NULL in the left outer table.

The one for the 70-443 exam and one (short) one on 2005 Maintenance Plans