Well.. for SQL server... Do you have access to the database server? You can use a perfmon to see current connections.
Also, for SQL 2000 you can use Enterprise Manager (Management - Current Activity) and for SQL 2005 you can use SQL studio. Jacob -----Original Message----- From: Tom G [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 02, 2007 7:56 AM To: CF-Talk Subject: Check database connections Anyone know how to see how many database connections are currently open to a particular database? Without having to ask a DBA to check? The app runs on MX7. It connects to both an Oracle database and a SQL Server database. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276770 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4