Viewing 15 posts - 3,406 through 3,420 (of 6,216 total)
Third option is to add logging code to each proc. With 700 procs it would be worth writing some code to add it for you.
Im not opposed to method #1....
August 23, 2002 at 5:27 am
Dont think its normal, but I'd have to double check to be 100% certain. Not uncommon for 3rd party controls to open additional connections unknown to you, but I think...
August 23, 2002 at 5:25 am
Perfmon lets you schedule start/stop, thats one way.
Andy
August 22, 2002 at 5:59 pm
Not directly. One way would to write a small app that processes the audit file - maybe grabbing a page of data at a time, prints it, deletes or marks...
August 22, 2002 at 5:17 pm
Normally if you run reconfigure and its not enough, it will tell you to run with override. Strange but true. Run from any db, doesnt matter, affects system settings.
Andy
August 22, 2002 at 5:13 pm
We're a small company, hasnt been much of an issue. In most cases they also have access to a local copy of SQL to experiment on, in rare cases I'd...
August 22, 2002 at 5:12 pm
Yes you can run it live. Not running it just means the changes are available yet. Sometimes its reconfigure, sometimes reconfigure with override.
Andy
August 22, 2002 at 1:56 pm
August 22, 2002 at 1:54 pm
Nope. Is this in general, or following a big delete/truncate? Do you update stats manually or set the db option? What SQL version?
Andy
August 22, 2002 at 1:52 pm
Think I looked at that once a long time ago. Suggest profiling to see what bits its checking to determine that it cant be dropped. Then override that. Tried switching...
August 22, 2002 at 11:30 am
I like to review the readme.txt to see if they've fixed anything that might be something I've had a problem with or just is close to an area thats important....
August 22, 2002 at 11:28 am
Interesting. For any one file, using a table lock would probably work, but are you looking to keep the results consistent across multiple files? Was thinking you could generate a...
August 22, 2002 at 5:04 am
Thats it. Also good to remember that if you're tight on disk space have to be careful about optimizing, between growth in the mdf and the large number of transactions...
August 21, 2002 at 6:53 pm
Guess I forget to mention all the fine points - at least I did mention replication early in the thread!
Queued updates is definitely interesting. No one ever seems to like...
August 21, 2002 at 5:22 pm
Definitely need to dig into it some. Are any encrypted? Havent tested to see if they copy or not. Maybe they are referencing something else you're missing? Scripting them out...
August 21, 2002 at 5:18 pm
Viewing 15 posts - 3,406 through 3,420 (of 6,216 total)