[cfaussie] Re: OT: DROP Database

[Andrew Scott]

Dale,   Must admit I am not to sure what your saying, a table is never locked for a great length of time   And your saying something like this will not work?     SET TRANSACTION ISOLATION LEVEL SERIALIZABLE GO BEGIN TRANSACTION GO PRINT N'Dropping table [dbo].[dmRedirect]' GO DROP TABLE [dbo].[dmRedirect]     Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613  8676 4223 Mobile: 0404 998 273   From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Dale Fraser Sent: Wednesday, 5 July 2006 4:14 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: OT: DROP Database   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 -~----------~----~----~----~------~----~------~--~---