You can delete as many rows from the table as you like. The trigger fires FOR EACH ROW, so is fine handling one record. Test it, you'll see. Just do...

You have a data mismatch between what your attempting to insert into the table, and what the table expects. Do an explicit conversion on your inserted value, and it will...

If we were to be given the table structure, we would be able to help much more efficiently.....

Having a default value and being optional are different things entirely.......the view is correct.

I do not have an answer for where to find the optional designatore though, as I always...

This is a case where dynamic sql is the only way......do a remote execute statement.....

Execute Otherdatabase.dbo.sp_execute "Drop ....."

The only limit I've run into, has been in the distribution database being too busy to keep up.......the replcommands table gradually gets larger and larger, and isn't able to ever...

I don't argue that RAID 10 is great....I wish I could do that......I just wondered at the logic of it, as I get the "it's not cost effective" argument.....If someone...

According to the layout you show, it will all be on F, as that is designated as SQL Databases......which would be what holds data.....

What is the division of the 4...

Yes, it is possible.......just not through the GUI wizard.....you have to build it out manually through script

set up the publications to do the replication through using procs, then modify the...

In general, Yes, a unique index should be faster than a non-unique one. This is based on size of the index, and data per page. An index having hundreds of...

Most efficiently......a very good solution overall....

QUOTE : "long resource using code is usually not needed just get the create table statement and the create index statements for the table?"

Of course, you are absolutely right......and of...

I just sent them to you.....

I can't help but still think your missing the point here......which is to identify foreign key fields within a database of maybe hundreds of tables and possibilities which have no...

With the structures in place, and an understanding of the procs I wrote for it, not long at all.....a few hours maybe just to test the setup.....it's VERY straightforward.....and I...