regards,
You can change the "max worker threads" option in SQL Server by running the statements below:
sp_configure 'show advanced options',1
reconfigure
go
sp_configure 'max worker threads',255
reconfigure
go
For more information about this option, please take a look at:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_config_09wu.asp
|||the problem is how can i configure my customer's SQL Server configuration. Now, i get one way. is it the right one?
Data Source=XXX;database=XXX;UID=XXX;PWD=XXX;MAX POOL SIZE=5
|||Sorry for misunderstanding. Yes the MAX POOL SIZE property should work in this case.
