Hey thanks,

A good idea. It would be a very good solution. Have to discuss with the team about the same.

Thanks

My application is for sales submission. There are more than 400 users who use the application only for 2 days in a month. So the application has lot of hits...

Hi krayknot,

thanks for the reply.

few doubts.

1. Can SQL server handle any pool size specified from the application

Ex if i specify size as 300 or 400 the SQL server will handle...