[cfaussie] Re: OT: DROP Database

[Dale Fraser]

Andrew,   I did a bit of a search and there is a SP sp_who2 which lists all the processes, including what DB’s   So I could loop through that and then issue a kill on all the relevant processes.   I thought there might be an easier way, like a force option on DROP or a CLEAR command. Regards Dale Fraser From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Andrew Scott Sent: Wednesday, 5 July 2006 15:56 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: OT: DROP Database   Dale,   Wouldn’t a SP work then call that via CF?     Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613  8676 4223 Mobile: 0404 998 273 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~----------~----~----~----~------~----~------~--~---