In a nutshell, you don't as you should always have a no count at the top of the SP anyway.
You can certainly return a variable of your choosing etc by using custom return codes - which may, or may not be as detailed as you want. "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: Wed Feb 28 04:58:19 2007 Subject: RE: Cfstoredproc message I suppose it's really a mssql question of trapping the generated message(s) and putting them in a var which can be returned to CF. How to do it though? > -----Original Message----- > From: Dinner [mailto:[EMAIL PROTECTED] > Sent: 28 February 2007 00:38 > To: CF-Talk > Subject: Re: Cfstoredproc message > > If you use java DB stuff, I assume it would be available... > > Probably not from the built in CF DB stuff tho. :-/ > > On 2/27/07, Richard Meredith-Hardy <[EMAIL PROTECTED]> wrote: > > 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? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270921 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4