Michele,
It almost certainly would be accepted. But note that a better alternative
might be to turn it into XmlIn query if it detects that.
I have a couple of posts about this issue.
Another option might be to turn that in into a sub select, but we need to
test the performance of ti
On Mon, Oct 6, 2008 at 11:45 AM, Michele Cantelli <[EMAIL PROTECTED]>wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
