• No idea. I'm not real sure what the groups are supposed to look like. Someone who is actually a 2000 dba will have to look at it. I'm a developer and my database gets restored from a copy from production. Most of the users from the prod database don't have logins on my dev server so my results are mostly garbage.

    BTW you can get the default db on SQL2K with:

    l.dbname AS Default_db_Name,

    On the first go, I just nulled it out because I hadn't looked at it closely enough to find the 2000 equivalent of the 2005 field. I don't think 2000 has schemas.