[cfaussie] Re: OT: DROP Database

Andrew Scott Tue, 04 Jul 2006 23:18:13 -0700

Dale,

Have you scripted this in a cfquery and tested it at all?

For example

If exists(tablename) drop table

</cfquery>

Of course that is puesdo code.

Or you could write it as a StoredProc and call it from CF. For safety you might want to wrap it in a transaction to stop others from accessing it while the sql/pl is being run.

And the new job is going great. See the thing is that CF might have a lock to the datasource, but if you run the sql in the database query designer or some ogther DB tool, it should not care if wrapped in transactions if something has a lock because if I recall right the transaction will queue the query.

And if I recall right Red-Gate sql runs DTS scripts that check if the table exists, then drops it all wrapped in a transaction otherwise do nothing, and this is even if the database is locked by CF. Did that with one of Nusphers biggest smaller clients many times with SQL Bundle, while she was using the database.

Senior Coldfusion Developer

Aegeon Pty. Ltd.

www.aegeon.com.au

Phone: +613 8676 4223

Mobile: 0404 998 273

From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Dale Fraser
Sent: Wednesday, 5 July 2006 4:02 PM
To: [email protected]
Subject: [cfaussie] Re: OT: DROP Database

Andrew,

What kind of answer is that, it’s a question?

Do you have one to show me? I’ve done a bit of searching without much luck, I’m sure it’s possible.

PS: How’s the new job?

Regards
Dale Fraser

From: [email protected] [mailto:[email protected]] On Behalf Of Andrew Scott
Sent: Wednesday, 5 July 2006 15:56 PM
To: [email protected]
Subject: [cfaussie] Re: OT: DROP Database