Post reply

User groups not displaying properly in EM

  • December 24, 2004 at 12:14 pm

    #66941

    Hi,

    I have a SQL 2000 database with about 100 user roles.  When I add a new user to the database and want to add them to a role the list of roles is not listed in alphabetical order.  Is there a way to sort this list, or is it a bug?

    Thanks,

    DMason

  • December 24, 2004 at 12:47 pm

    #534987

    100 roles! Yikes. I've never had that many, but I suspect it's some type of bug.

    I'd learn the T-SQL and just script it.

  • December 24, 2004 at 1:38 pm

    #534988

    I think I see the problem.  The list is displaying by the uid from the sysusers table for that database.  Unfortunately the name field isn't alphabetical in relation to the uid.  I don't see any easy way to fix that.

    Besides using T-SQL I still have the option, in Enterprise Manager, of opening each role I want to add the member to and add them that way.

    Thanks for your help and best of the holidays to you!

    DMason

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply