Not quite what I'm looking for, I think. This is actually a sp which contains a RESTORE DATABASE command and I'm interested to capture the stuff which goes into messages like:
Processed 10240 pages for database 'xxxxxx', file 'xxxxxxx' on file 1. Processed 1 pages for database 'xxxxxxxxx', file 'xxxxxxxxxx_log' on file 1. RESTORE DATABASE successfully processed 10241 pages in 11.732 seconds (7.150 MB/sec). How do I capture that? > -----Original Message----- > From: Robertson-Ravo, Neil (RX) > [mailto:[EMAIL PROTECTED] > Sent: 27 February 2007 07:45 > To: CF-Talk > Subject: Re: Cfstoredproc message > > Well if it is success or not then you just use the return > codes. If you want a specific user defined message you will > have to select it into a var and return it as an OUT or as a > resultset. > > > > > > "This e-mail is from Reed Exhibitions (Gateway House, 28 The > Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a > division of Reed Business, Registered in England, Number > 678540. It contains information which is confidential and > may also be privileged. It is for the exclusive use of the > intended recipient(s). If you are not the intended > recipient(s) please note that any form of distribution, > copying or use of this communication or the information in it > is strictly prohibited and may be unlawful. If you have > received this communication in error please return it to the > sender or call our switchboard on +44 (0) 20 89107910. The > opinions expressed within this communication are not > necessarily those expressed by Reed Exhibitions." > Visit our website at http://www.reedexpo.com > > -----Original Message----- > From: Richard Meredith-Hardy > To: CF-Talk > Sent: Tue Feb 27 06:45:39 2007 > Subject: Cfstoredproc message > > Simple question, I hope.... > > How does one get back to CF the message a stored proc > normally puts in the messages window when you run it in SQL > Server management studio or enterprise manager? > > Thanks in advance > > Richard > > (I've hunted around but difficult to search for the word 'message'...) > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270748 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
