Working with Rhino.Security and I found a limit  when using SQL Server as
DBMS: if a user is contained in more than 2,100  UsersGroups NHibernate
throws SqlException:  "The incoming tabular data stream (TDS) remote
procedure call (RPC) protocol stream is incorrect. Too many parameters were
provided in this RPC request. The maximum is 2100."

 

I identified the problem in the PermissionsService where a query with
Expression.In("UsersGroup", usersGroups) is generated. 

Googling about this SQL Server issue I see a lot of ppl who face this
problem splitting the query and batching the execution, anyway I don't think
that a patch like this for the PermissionsService would be accepted, right?

 

 


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"Rhino Tools Dev" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/rhino-tools-dev?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to