Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mat_cottrell
Starting Member
1 Post |
 Posted - 2006-12-15 : 12:36:34
|
| Hello All,Great forum!I have been asked to find a way to enable a user to disable/enable a foreign key constraint on 2000.After some investigation I have concluded that the user needs to be a member of the db_ddladmin database role.I don't want to advise putting the users in this role on a production database. Please don't ask why we need to disable and enable foreign keys on a production database, I havn't asked and I'm not sure I want to either!Can I use a stored procedure to do this?ThanksMat |
|
|
|
|
|
Permissions problems