June 5, 2009 at 5:06 pm
I have a method in a C# application that invokes the sp_helprole procedure to derive the roles for the specified database. I have reviewed the result set generated via the ExecuteReader() method against the results of this procedure executed in SQL Server Management studio. In both instances the RoleNames in the results are identical. However, I have found that the RoleId values for user defined roles do not match. In Management studio, the roles that I have added are numbers less then 10 while in the C# result set the RoleId of the roles that I have added start with 16400.
Has anyone else encountered this scenario? Does anyone have any suggestions as to why there is a difference between the 2 result sets?
June 5, 2009 at 5:25 pm
Please ignore this post; I resolved the issue
June 5, 2009 at 8:28 pm
You asked for help, forum etiquette asks that you post your resolution. Others may have a similar problem and seeing how you resolved the problem may help.
June 8, 2009 at 10:56 am
I did not post the resolution because it was simply my blunder. I had query sessions opened with 3 different servers comparing data. When I compared the call from my C# code I inadvertently had switched to the wrong server so I was comparing apples and oranges. So no resolution to post just a gaffe on my part.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply