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 generate. If I
feed CFQUERY something like
DBCC SHOWCONTIG ('activitylog')
I'd like to be able to get at the 10 or so lines of of output that it would
normally generate interactively. But no result set is even created by such a
query, and I cannot see how to get to the data. I've tried variations of
EXECUTE and subqueries, all with no luck. Is this an impossible dream?
thanks
Reed
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250011
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
