An 85 MG SQL statement? How big is that database? Table copies in TOAD would take less time than that.
On Tue, Jan 6, 2009 at 9:35 PM, Michael Kear <[email protected]> wrote: > Anyway.. . by a circuitous route, I found out about the Database > Publishing Wizard, and I'm surprised that in all my fussing and yelling at > MS about this problem, no one there thought to tell me about it. Anyway I > downloaded it, and it gives me a 85MB long SQLstatement (or series of > statements) that takes an hour to execute. Means in order ot update the > database, I cant upload the changes, I have to upload the whole database, > and take the site off line for an hour. I'm pretty grumpy about that but > it's a step forward, if only a small one. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3171 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
