Right click on the servers properties in Enterprise Manager (you know the one with the play icon and red snake...:-) and select connections. Make sure Maximum Concurrent User Connections is equal to 0 (this equals unlimited and will let SQL Server thread as needed.)
HTH Neil 'I really must buy a watch, but I just cant find the time.' <!------------------------------ Neil Clark Senior Web Applications Engineer ColdFusion / Spectra / Sitespring Macromedia Alliance Partner MCB Digital Limited [T]: 020 8941 3232 [F]: 020 8941 4333 [M]: 07719 448 227 [E]: [EMAIL PROTECTED] [www] www.fluidik.com --------------------------------> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

