--Janis


I have one other question. How do you define roles What role(s) are required to fully administer SQL Server What role(s) are required to fully administer a single database in SQL Server

thanks,



Re: admin or other role

Arnie Rowland


In Books Online, look up [fixed server roles] and [fixed database roles].

Those roles are predefined. You can also create your own roles (which only has permissions that you grant to them.)

Full server administration = sysadmin.

Single database administration = db_owner.