how to find out who are in BUILTIN/Administrators Group?

sql2k, nt5
Does anyone know how to find out who are the members in
BUILTIN/Administrators group in SQL Server. (when I'm not in a NT domain
admin group and can't see nt account info from the NT side).
thank you.
The BUILTIN/Administrators group maps to the Windows Local administrators
group. If you can't see who's in the Windows group, you can't find out who's
in BUILTIN/Administrators.
Jacco Schalkwijk
SQL Server MVP
"Steve Lin" <lins@.nospam.portptld.com> wrote in message
news:%23W8uAl7JEHA.3980@.TK2MSFTNGP10.phx.gbl...
> sql2k, nt5
> Does anyone know how to find out who are the members in
> BUILTIN/Administrators group in SQL Server. (when I'm not in a NT domain
> admin group and can't see nt account info from the NT side).
> thank you.
>
|||You can try
exec master..xp_logininfo 'BUILTIN\Administrators','members'
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Steve Lin" <lins@.nospam.portptld.com> wrote in message
news:%23W8uAl7JEHA.3980@.TK2MSFTNGP10.phx.gbl...
> sql2k, nt5
> Does anyone know how to find out who are the members in
> BUILTIN/Administrators group in SQL Server. (when I'm not in a NT domain
> admin group and can't see nt account info from the NT side).
> thank you.
>
|||that's very helpful. thank you!!!
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:ObGoTa8JEHA.644@.tk2msftngp13.phx.gbl...
> You can try
> exec master..xp_logininfo 'BUILTIN\Administrators','members'
> --
> HTH
> Jasper Smith (SQL Server MVP)
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>
> "Steve Lin" <lins@.nospam.portptld.com> wrote in message
> news:%23W8uAl7JEHA.3980@.TK2MSFTNGP10.phx.gbl...
>

how to find out who are in BUILTIN/Administrators Group?

sql2k, nt5
Does anyone know how to find out who are the members in
BUILTIN/Administrators group in SQL Server. (when I'm not in a NT domain
admin group and can't see nt account info from the NT side).
thank you.The BUILTIN/Administrators group maps to the Windows Local administrators
group. If you can't see who's in the Windows group, you can't find out who's
in BUILTIN/Administrators.
Jacco Schalkwijk
SQL Server MVP
"Steve Lin" <lins@.nospam.portptld.com> wrote in message
news:%23W8uAl7JEHA.3980@.TK2MSFTNGP10.phx.gbl...
> sql2k, nt5
> Does anyone know how to find out who are the members in
> BUILTIN/Administrators group in SQL Server. (when I'm not in a NT domain
> admin group and can't see nt account info from the NT side).
> thank you.
>|||You can try
exec master..xp_logininfo 'BUILTIN\Administrators','members'
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Steve Lin" <lins@.nospam.portptld.com> wrote in message
news:%23W8uAl7JEHA.3980@.TK2MSFTNGP10.phx.gbl...
> sql2k, nt5
> Does anyone know how to find out who are the members in
> BUILTIN/Administrators group in SQL Server. (when I'm not in a NT domain
> admin group and can't see nt account info from the NT side).
> thank you.
>|||that's very helpful. thank you!!!
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:ObGoTa8JEHA.644@.tk2msftngp13.phx.gbl...
> You can try
> exec master..xp_logininfo 'BUILTIN\Administrators','members'
> --
> HTH
> Jasper Smith (SQL Server MVP)
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>
> "Steve Lin" <lins@.nospam.portptld.com> wrote in message
> news:%23W8uAl7JEHA.3980@.TK2MSFTNGP10.phx.gbl...
>

how to find out who are in BUILTIN/Administrators Group?

sql2k, nt5
Does anyone know how to find out who are the members in
BUILTIN/Administrators group in SQL Server. (when I'm not in a NT domain
admin group and can't see nt account info from the NT side).
thank you.The BUILTIN/Administrators group maps to the Windows Local administrators
group. If you can't see who's in the Windows group, you can't find out who's
in BUILTIN/Administrators.
--
Jacco Schalkwijk
SQL Server MVP
"Steve Lin" <lins@.nospam.portptld.com> wrote in message
news:%23W8uAl7JEHA.3980@.TK2MSFTNGP10.phx.gbl...
> sql2k, nt5
> Does anyone know how to find out who are the members in
> BUILTIN/Administrators group in SQL Server. (when I'm not in a NT domain
> admin group and can't see nt account info from the NT side).
> thank you.
>|||You can try
exec master..xp_logininfo 'BUILTIN\Administrators','members'
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Steve Lin" <lins@.nospam.portptld.com> wrote in message
news:%23W8uAl7JEHA.3980@.TK2MSFTNGP10.phx.gbl...
> sql2k, nt5
> Does anyone know how to find out who are the members in
> BUILTIN/Administrators group in SQL Server. (when I'm not in a NT domain
> admin group and can't see nt account info from the NT side).
> thank you.
>|||that's very helpful. thank you!!!
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:ObGoTa8JEHA.644@.tk2msftngp13.phx.gbl...
> You can try
> exec master..xp_logininfo 'BUILTIN\Administrators','members'
> --
> HTH
> Jasper Smith (SQL Server MVP)
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>
> "Steve Lin" <lins@.nospam.portptld.com> wrote in message
> news:%23W8uAl7JEHA.3980@.TK2MSFTNGP10.phx.gbl...
> > sql2k, nt5
> >
> > Does anyone know how to find out who are the members in
> > BUILTIN/Administrators group in SQL Server. (when I'm not in a NT domain
> > admin group and can't see nt account info from the NT side).
> >
> > thank you.
> >
> >
>

How to find out the total number of commited transactions on SQL2k?

Dear all,

Previously I posted this issue on SSIS newsgroups and I did not obtain any response so that I'll do here.

Using this system function (::fn_log(null,null)) you can find out how many transactions have been confirmed in your .LDF. Although by means of another system function you can see further information, such as statitical.

Any help would be very appreciated.

Thanks in advance and regards,

sp_monitor among them