Thanks

Will take a look.

Regards,

Sudhir

Hi 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...

Hi 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...

Hi Hans,

I am not getting any error, I have executed it & there is no

Hi,

Thanks for the reply. Noted your point. Will take care of this in future.

Regards,

Sudhir