Thanks Carlos, I thought it was great as well.

Apparently not many others have time for a 9 page interview , maybe they'll read it...

There is data in the system tables that marked things are replicated. That's why they appear in SSMS. You can manually reset things in the system tables, but you'd need...

Note that it is running on the server, not your machine. So the path from the server, with the SQLAgent login logged in is what must be checked.

JT, maybe you want to write my editorial one day

I started with DBase/Clipper, no DRI there. You can to manually open each...

I agree, this is not recommended. I'd rather have you use VBScript to read some Outlook mailbox on another machine and then do an insert into SQL Server.

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...