Limit to number of connections to the SQLCLR?

Is there a limit to the number of connections that can be made to the SQLCLR? If so, what is that limit and is it adjustable?

Thanks!

If you are referring to the way prior versions of MSDE 2000 were limited to 25 concurrent connections the answer is no.

Hope that helps. Let us know if you have any further questions.

|||

No, I am referring to access to the SQLCLR from any edition of SQL Server 2005. 2005 does not by default limit the number of user connections to the SQL Server instance. Internally to SQL Server, is there a limit to how many connections to the SQLCLR that can be made?

So for example, if had 1,000 connections open to SQL Server, will I be limited to only 200 (or some number) of them accessing SQLCLR procedures? Or, assuming server resources are adequate, can an unlimited number of clients access SQLCLR procedures concurrently?

|||You cannot specify a hard limit of concurrent users of CLR in SQL. You will get as many CLR users as your resources permit.