One approach for this is to have the procedures owned by a datbase role. The role is given explicit permissions to create stored procedures. The users are...

I would not recomend giving DBO to any one. You can grant them explict permissions to be able to create views. This is done if you right click on the...

We have been using Veritas for two years now for our SQL servers. I would definitely recommend it. It does a very nice job restoring the system database and permissions....

You might want to try stopping the service and Then in the start parameters put /m and restart the service. This will start the instance in single user mode.

If you assign them the db_ddladmin role they can alter objects owend by dbo. It will promt them with a warning but thats all.

You dont have to give them sysadmin rights or DB owner to add new users to roles. If you give them securityadmin server role and then in the database give...