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

Reply via email to