Let's say i have created a database and i want to distribute a copy of that database to a third party company, in order to fill in some data but not to delete any existing records. If the database contains a trigger, is it possible to protect that trigger from modifying or deleting it by the third party company? Is it possible to protect the database from deleting any existing records? I guess, if i can protect a trigger, then it is possible.
What is the appropriate way to give a database copy to the third party company? Can i just give them a copy of the mdf and ldf files?