mail2payan (5/10/2013)
Dear InoLand,Thank you for this valuable suggestion.
The insert part will one-by-one only, not multiple insert as this a very crucial part and that's why only one person will have the right to do so and that also one at a time.
Hope, now I may can overcome the issue to some extent?
OK -- if you can keep the input limited to one row at a time, your approach will work. Just keep in mind that it is a limitation of the design. As a compromise, you might want to consider having your trigger check INSERTED for more than one row and failing with an error message if it happens rather than having to track down later why there are entries in your Project table which do not have directories.
- Les