Heya James, Thanks for that!
Query Analyser dropped the indexes almost immediately... I'll remember that for next time. bye Thursday, February 19, 2004, 10:17:27 AM, you wrote: JM> hmm - that doesn't seem that unreasonable. (Well maybe it is, but recently experienced a similar thing on sql7.0 so I wouldn't expect 2k to be that much better) Think I ended up doing it through JM> query analyser as it seems to be more stable when you do big things. JM> I hope that's not a production server? ;-) JM> best of luck, JM> - J ----------------------- Ryan Sabir Newgency Pty Ltd 2a Broughton St Paddington 2021 Sydney, Australia Ph (02) 9331 2133 Fax (02) 9331 5199 Mobile: 0411 512 454 http://www.newgency.com/index.cfm?referer=rysig --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
