• Under the section labeled "The SA Account" you have the following statement regarding the "sysadmin" role,  "Never grant this privilege to any other user, there is simply no reason to in a production environment.<O> "  I wonder if this holds true regardless of the environment and number of DBA's.  </O>

    <O>In our environment we have three DBA's that share responsibility for mananging our production SQL Server environment.  We all know the SA password, and could use it to perform production work if we chose to go that route.  But instead each DBA has a SQL Server Logon for performing sysadmin duties.  We have done this for audit trail purposes.  Doing this allows us to identify which DBA has done what.  If we shared the SA account we won't be able to determine which DBA has made a particular change. </O>

    Gregory A. Larsen, MVP