Database Admin Security Permissions

Hi,
We installed SQL 2000 Tools only (Enterprise manager) on
the database admins pc's, and now we want to setup
permissions for the database admins to only be able to do
database administration.
Should I use Windows authentication, (how do I setup just
enough permissions?) or SQL Authentication (how do I do
that?) Is there a whitepaper for this? What is the best
practice?
Thanks,
Judith
Hi,
What ever authentication, If you set the SYSTEM ADMIN role to DBA person, he
can do administration as well as any changes to databases .
Why should you restrict access to database administrators? Normally in all
enterprises he is the guy who is responsible
for your datbase server. So no need to protect the access from him
Thanks
Hari
MCDBA
"Judith" <anonymous@.discussions.microsoft.com> wrote in message
news:12b9801c44339$5cf78a20$a401280a@.phx.gbl...
> Hi,
> We installed SQL 2000 Tools only (Enterprise manager) on
> the database admins pc's, and now we want to setup
> permissions for the database admins to only be able to do
> database administration.
> Should I use Windows authentication, (how do I setup just
> enough permissions?) or SQL Authentication (how do I do
> that?) Is there a whitepaper for this? What is the best
> practice?
> Thanks,
> Judith
>
|||Well, I could think of this myself! But the question is
that that I want to restrict access for database admins,
because it's a different department and responsibility. So
our enterprise is a little different. Does anybody knows
more about this subject?
Thanks in advance!!!

>--Original Message--
>Hi,
>What ever authentication, If you set the SYSTEM ADMIN
role to DBA person, he
>can do administration as well as any changes to
databases .
>Why should you restrict access to database
administrators? Normally in all
>enterprises he is the guy who is responsible
>for your datbase server. So no need to protect the access
from him
>Thanks
>Hari
>MCDBA
>
>"Judith" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:12b9801c44339$5cf78a20$a401280a@.phx.gbl...
do[vbcol=seagreen]
just
>
>.
>

databas size

I am looking for script to give the Data and log files of each Database on
the server including the size of each file.
can you help<msnews.microsoft.com> wrote in message
news:e$$FnV8dHHA.1220@.TK2MSFTNGP03.phx.gbl...
>I am looking for script to give the Data and log files of each Database on
>the server including the size of each file.
> can you help
>
SQL Server 2005:
SELECT * FROM sys.master_files;
SQL Server 2000:
SELECT * FROM master.dbo.sysaltfiles;
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||You can also use the below system proc.
sp_MSforeachdb 'sp_helpdb ?'
Thanks
Hari
<msnews.microsoft.com> wrote in message
news:e$$FnV8dHHA.1220@.TK2MSFTNGP03.phx.gbl...
>I am looking for script to give the Data and log files of each Database on
>the server including the size of each file.
> can you help
>|||Hi
http://dimantdatabasesolutions.blog...
se.html
<msnews.microsoft.com> wrote in message
news:e$$FnV8dHHA.1220@.TK2MSFTNGP03.phx.gbl...
>I am looking for script to give the Data and log files of each Database on
>the server including the size of each file.
> can you help
>

databas size

I am looking for script to give the Data and log files of each Database on
the server including the size of each file.
can you help
You can also use the below system proc.
sp_MSforeachdb 'sp_helpdb ?'
Thanks
Hari
<msnews.microsoft.com> wrote in message
news:e$$FnV8dHHA.1220@.TK2MSFTNGP03.phx.gbl...
>I am looking for script to give the Data and log files of each Database on
>the server including the size of each file.
> can you help
>
|||Hi
http://dimantdatabasesolutions.blogspot.com/2007/03/detaching-and-attaching-database.html
<msnews.microsoft.com> wrote in message
news:e$$FnV8dHHA.1220@.TK2MSFTNGP03.phx.gbl...
>I am looking for script to give the Data and log files of each Database on
>the server including the size of each file.
> can you help
>