Hello, I just wanna ask if the sp_helpuser in sql2005 and sp_helpuser in sql2008 has difference... I have a database that was created in sql2005... when I back-up the database and restore it in sql2008... sp_helpuser return a column RoleName.... but the application running the database doesnt work like before... I checked it and it retrieve a cloumn named GroupName from hp_helpuser... so I assume hp_helpuser in 2005 return GroupName that why I change my codes to retrieve RoleName instead of GroupName since I am running sql2008 now.....

Thank you hope you could help me...

• Edited by pantherLily 1 hour 27 minutes ago

Hello,

Yes, the result set has change from 2005 => 2008, the column "Group_Name" was renamed to "Role_Name", it suits better. You can compare it in MSDN

https://msdn.microsoft.com/en-us/library/ms187732(v=sql.90).aspx
https://msdn.microsoft.com/en-us/library/ms187732(v=sql.100).aspx