Blank password

Is this possible to know if there some blank password in my users.By blank I assume you mean no password. Yes, you can actually check this by
doing a simple SELECT on syslogins.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Chris" <anonymous@.discussions.microsoft.com> wrote in message
news:C96827A2-4545-4D53-9CF6-6BEAAC55319F@.microsoft.com...
> Is this possible to know if there some blank password in my users.|||Hi,
The query will be,
select name from syslogins where password is null
Thanks
Hari
MCDBA
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OwAdMhdDEHA.684@.tk2msftngp13.phx.gbl...
> By blank I assume you mean no password. Yes, you can actually check this
by
> doing a simple SELECT on syslogins.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "Chris" <anonymous@.discussions.microsoft.com> wrote in message
> news:C96827A2-4545-4D53-9CF6-6BEAAC55319F@.microsoft.com...
>