Home Forums Article Discussions Article Discussions by Author Discuss content posted by shiva challa List all Usernames, Roles for all the databases. RE: List all Usernames, Roles for all the databases.

  • August 28, 2008 at 8:29 am

    #864438

    I get the following error when running the query against one of my servers:

    Msg 102, Level 15, State 1, Line 14

    Incorrect syntax near '-'.

    (260 row(s) affected)

    (260 row(s) affected)

    ... I have a user named 'dotnet-apps' that seems to be causing the problem. The result set still displays all the other users, just not the 'dotnet-apps' account.

    "Key"
    MCITP: DBA, MCSE, MCTS: SQL 2005, OCP