The reason for this is that there are replication tables included in the database that was backed up. If you look at the tables, you'll see them. This causes Sql...

After having writen reviews on most of the ones on the market, I can tell you there are no monitoring tools which meet ALL of your requirements.

Drop off the cluster...

Try this, it should give you what you need....

http://www.sqldts.com/default.aspx?302

using an smtpsendmail proc works well too.......I prefer them as most of my environments do not allow sql mail to be set up.

Active Active clustering is a good candidate for applications which can be broken into logical segments as well. An application which handles Provisioning on one database server, and Ordering on...

Locks on tables are not released until the transaction doing the locking commits. The proper way to handle this is to restructure the transaction to either not last so long,...

When using the showplan, it will not generate plans for queriess using temp tables, or remote execution procs, etc....

While your script is very cool, the only real option is actually...

Just as a FYI, you can also adjust schema generation, and data in generating the publication as well. This will save you time and resources in generating the publication. After all, why generate...

chopeen's suggestion is what I use........

Although many of the client's I've worked for end up turning it off for the very reasons our collegues have expressed above, I've found that it's better to work with...

I think that I would work at attempting to find another solution. It may be that the impact from a de-normalized table, and overhead of the triggers doesn't affect you...

I generally attach my spreadsheet as a linked server. Then you can truncate, insert, select, etc...

I have a proc that I pass the unc filename to, the alias to call...

60 - 78K for a 8 - 10 year guy?

I know guys graduating from college this year with 0 yrs experience, being offered 65K.....Is it just the area your...

The reason that the 1500 were able to be deleted, was because there were no duplicates within those 1500. So long as that is the situation, there is no issue....

The issue will be found in not having a unique identifier for the table. This unique identifier must exist in order to delete records properly.

Edited by - scorpion_66 on 04/16/2003...