f.racionero (10/17/2007)

---

Normally I use this script to get all user information for a db

select

[Login Type]=

case sp.type

when 'u' then 'WIN'

when 's' then 'SQL'

when 'g' then 'GRP'

end,

convert(char(45),sp.name) as srvLogin,

convert(char(45),sp2.name) as...

john.arnott (4/15/2010)

---

Excellent!...

Tao Klerks

The sentence "NULL does not equal NULL" is correct, when you have ANSI_NULLs on...

On the other hand, the statement "Try comparing two NULL values in SQL - they will...