Using CFQUERY to access DBCC output?

2006-08-16 Thread powell
I'm trying to automate some of an application's database maintentance tasks via a CF script that will check to see if it's time for a defrag, index rebuild, etc. I know that I can put a DBCC statement in a CFQUERY, but what's got me scrambling is how to retrieve any output that the DBCC might

Re: Using CFQUERY to access DBCC output?

2006-08-16 Thread Dan Plesse
It sure sounds like you need a socket with a listener. I would find an example already on the web and use that or add a request for CF 8 to add a feature to tags which allows for internal objects to be extended cfquery name=hello extended= com.new.feature Override addlisterner() method. On

Re: Using CFQUERY to access DBCC output?

2006-08-16 Thread Denny Valliant
You can also use native JDBC drivers and a java-esk JDBC connection to get back more info than CF gives you. Don't know if it would work in this case... :Denny On 8/16/06, Dan Plesse [EMAIL PROTECTED] wrote: It sure sounds like you need a socket with a listener. I would find an example