Viewing 15 posts - 1,411 through 1,425 (of 6,216 total)
Just do the whole restore again. If you have Log Explorer or something similar, you could rollback the changes out of the transaction log.
Andy
October 31, 2003 at 2:10 pm
October 31, 2003 at 2:09 pm
October 31, 2003 at 2:08 pm
I use the filesystemobject via VBScript to check file sizes.
Andy
October 31, 2003 at 2:07 pm
Before you go through all that, I'd check to see if you can get better performance, either by tuning or by buying more hardware. Can you post a query plan...
October 31, 2003 at 2:03 pm
Same thing happen when you're connected to the server? I'd run from the server directly with the network cable disconnected, see if any change. Are you running C2 auditing or...
October 31, 2003 at 2:00 pm
The drive probably isnt mapped for the SQL Agent account. Using the full network path is a decent method anyway.
Andy
October 31, 2003 at 1:58 pm
Using 'not in' doesnt usually optimize well, you might try rewriting it in a different form. Not the best answer I know. Could also do a pass through query.
Andy
October 31, 2003 at 1:56 pm
Try this:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q300676
If not, I'd recommend a support call.
Andy
October 31, 2003 at 1:54 pm
There is a registry setting somewhere that will generate a text representation of the query plan that Access/Jet is using. One of these days I'll research some more, curious what...
October 31, 2003 at 1:53 pm
Vb6.
Steven, copying the table is an option (and not a bad one), sometimes I just like to explore - never know what may turn out to be useful.
Andy
October 29, 2003 at 6:46 pm
Keith, do you have a reference that supports that? My experience (viewed, not tested) doesnt match that - I've got tables with 5 mil rows, dont see I could be...
October 29, 2003 at 4:45 am
I still use QA, plus VB6/VB.Net. Looking forward to better tools in Yukon!
Andy
October 29, 2003 at 4:42 am
Set rowcount has it's uses. One is to easily limit the results of a delete or update, the other is when you need to parameterize it. You can do set...
October 29, 2003 at 4:40 am
I'd be interested to hear the results if you try either product.
Andy
October 29, 2003 at 4:38 am
Viewing 15 posts - 1,411 through 1,425 (of 6,216 total)