InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 16:10:54 GMT20http://www.sqlservercentral.com/Forums/Topic601436-1415-1.aspxHi Sigal,Actually the only purpose to use cursor is to avoid DBO, SYS, INFORMATION_SCHEMA and Guest users, else we can directly execute sp_helpuser and it will return all user's role data.To avoid cursor, while creating #tmpuser table, we can add another field with identity column and then run a while loop. We have to run a loop to get roles of each user excluding system users. your comments are appreciated.ThanksSudhirThu, 09 Jul 2009 19:27:03 GMTSudhir-192949http://www.sqlservercentral.com/Forums/Topic601436-1415-1.aspxHi Hans,I am not getting "Insert Error: Column name or number of supplied values does not match table definition." Its working fine.Please try again & let me know if there it still give problem.ThanksSudhirThu, 09 Jul 2009 18:59:54 GMTSudhir-192949http://www.sqlservercentral.com/Forums/Topic601436-1415-1.aspxHi Hans,I am not getting any error, I have executed it & there is noThu, 09 Jul 2009 18:58:50 GMTSudhir-192949http://www.sqlservercentral.com/Forums/Topic601436-1415-1.aspxI receive this error:[i]Msg 213, Level 16, State 7, Line 2Insert Error: Column name or number of supplied values does not match table definition.[/i]This does not look well...Wed, 08 Jul 2009 08:31:17 GMTFreeHansjehttp://www.sqlservercentral.com/Forums/Topic601436-1415-1.aspxVersioning is too specific. You'll have to update this code everytime you apply a CU or SP. Why not just look at the first character? Show us how without the cursor, there must be a set-wise way to do this.Wed, 24 Dec 2008 09:29:38 GMTMyles Sigalhttp://www.sqlservercentral.com/Forums/Topic601436-1415-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Administration/64959/">Extract User-Role Mapping</A>[/B]Wed, 12 Nov 2008 08:24:52 GMTSudhir-192949