• I'm assuming that when you state

    We are a group of 3 people working and have the administartor password.

    you mean that you all share the same login (Sql log in I'm guessing).

    The best way for you to help this situation would be for you to to each have your own log in (this is a pretty widely adopted industry best practice). This login can be mapped to windows users/groups as needed. Now that you are all not accessing the database server with the same credentials we can talk about setting up the security for the various logins. Glenn has some good advice on how to do that. I'd only add to make certain to follow the principal of least privilege as you assign the various rights to the log ins. Only give someone what they really need to do their job.

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]