Yes, sp_who or select * from sysprocesses would work, but he stated that he didn't have access to the database server.
That is a good question. I bet there is something in service factory which will tell you. ~Brad -----Original Message----- From: Tom G [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 02, 2007 3:41 PM To: CF-Talk Subject: Re: Check database connections >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. No, we don't have access to the database server (for SQL Server). I was trying to find a way to check the number of connections through CF somehow. Haven't had much luck with that search. How about checking connections to an Oracle database? This SQL Server database is going to migrate to Oracle sometime in the near future. Plus, we have our own Oracle database (the SQL Server database is owned by an outside vendor and we just read from it). So if I can figure out how to check connections to an Oracle database I'll feel like I've made some progress. Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276824 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
