logins lock

hi ,
how can we lock and login on a sql server as we can do it
in sybase by sp_locklogin?
do we an alternate solution as we dont have sp_locklogin
sp in mssql 2k .Hi,
Only Windows based users can be locked. SQL server by itself do not have any
user or password polycies.
So for SQL server based logins we can not set the lockout option.
Thanks
Hari
MCDBA
"sid" <sid_m15@.coolgoose.com> wrote in message
news:571801c4811d$8d8e6290$a501280a@.phx.gbl...
> hi ,
> how can we lock and login on a sql server as we can do it
> in sybase by sp_locklogin?
> do we an alternate solution as we dont have sp_locklogin
> sp in mssql 2k .
>|||This will be possible for SQL logins in SQL2005 however.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:OtKeCpTgEHA.3548@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Only Windows based users can be locked. SQL server by itself do not have
> any
> user or password polycies.
> So for SQL server based logins we can not set the lockout option.
>
>
> Thanks
> Hari
> MCDBA
> "sid" <sid_m15@.coolgoose.com> wrote in message
> news:571801c4811d$8d8e6290$a501280a@.phx.gbl...
>|||thanks a lot
sid
>--Original Message--
>This will be possible for SQL logins in SQL2005 however.
>--
>HTH
>Jasper Smith (SQL Server MVP)
>http://www.sqldbatips.com
>I support PASS - the definitive, global
>community for SQL Server professionals -
>http://www.sqlpass.org
>"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in
message
>news:OtKeCpTgEHA.3548@.TK2MSFTNGP09.phx.gbl...
itself do not have[vbcol=seagreen]
lockout option.[vbcol=seagreen]
it[vbcol=seagreen]
sp_locklogin[vbcol=seagreen]
>
>.
>|||thanks a lot
sid
>--Original Message--
>Hi,
>Only Windows based users can be locked. SQL server by
itself do not have any
>user or password polycies.
>So for SQL server based logins we can not set the lockout
option.
>
>
>Thanks
>Hari
>MCDBA
>"sid" <sid_m15@.coolgoose.com> wrote in message
>news:571801c4811d$8d8e6290$a501280a@.phx.gbl...
it[vbcol=seagreen]
>
>.
>

login statistics

I am wondering if there is an sp in mssql server that is
equivalent to the sybase sp_reportstats.
This sp prints out the current accounting totals for all
logins, as well as each login's individual statistics and
percentage of the overall statistics.
eg
loginname, cpu, percent of cpu, I/O percent I/OHi,
Have a look into the procedure SP_WHO2 and the master..sysprocesses system
table.
Thanks
Hari
MCDBA
"Bola" <anonymous@.discussions.microsoft.com> wrote in message
news:18e0701c41bc5$9da48a50$a401280a@.phx
.gbl...
> I am wondering if there is an sp in mssql server that is
> equivalent to the sybase sp_reportstats.
> This sp prints out the current accounting totals for all
> logins, as well as each login's individual statistics and
> percentage of the overall statistics.
> eg
> loginname, cpu, percent of cpu, I/O percent I/O