Your problem is not a CFMX problem, it's an Enterprise Manager problem. Our DBA's at work got us out of the habit of using that and now we only use the Query Analyzer to look at and change data. IIRC, Enterprise Manager locks the rows which are open in the display pane (so that you can edit them).
- Brandon On Thu, 16 Dec 2004 12:59:56 -0800, Brook Davies <[EMAIL PROTECTED]> wrote: > We recently added a second server to our CFMX application and are running > now in this 2 server clustered environment. In the past we have always been > able to open SQl Server enterprise manager and view/edit data at the > database level. However, when we do this now, it looks like the CFMX > database requests on BOTH servers start to get queued. When we close the > table in the enterprise manager, the queued requests complete. > > In the CFADMIN we do NOT have a limit on the number of simultaneous DB > connections. Is this a setting within SQl Server somewhere? > > Brook > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188189 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
