Viewing 15 posts - 1,936 through 1,950 (of 6,216 total)
Hey, thats pretty cool, posting with an accent!
With luck, it would need to be really big binder, we're hoping to run 200+ original articles a year.
Let me throw out some...
July 8, 2003 at 4:09 am
Should work fine. Only time it would matter is if you use a named instance, to get that to work on the client you need MDAC 2.6 or higher.
Andy
July 7, 2003 at 3:40 pm
DMO has some objects that expose the service status.
Andy
July 7, 2003 at 12:46 pm
I think thats a natural sideaffect of using floats. I try to avoid them!
Andy
July 7, 2003 at 12:46 pm
Using a maintenance job you mean? Best you can do if you're really short on space is do one table/index at a time, or look at the defragindex option of...
July 7, 2003 at 12:38 pm
Generally you use dynamic allocation unless you've enabled AWE, which requires fixed. That's on a machine that runs SQL exclusively. If you're forced to share it with another app, then...
July 7, 2003 at 9:50 am
Greetings to you as well. I think you'll probably get better answers on a website targeting those environments. Might start with http://www.asp.net.
Andy
July 7, 2003 at 9:48 am
Depends on what access you have. You could set the job to retry more times if it fails, or set an alert to restart the job on this particular error....
July 7, 2003 at 9:46 am
Sometimes drop/create makes sense, sometimes not. It's the easiest way to go. For example, suppose after your initial snapshot you modify the subscriber table, maybe add a column and a...
July 7, 2003 at 9:44 am
There is an -inproc (spelling?) switch that lets you run multiple threads, that might distribute the workload.
Andy
July 7, 2003 at 9:42 am
I think that will work. Need to script out your jobs and script back in to get it all working again (before/after changing out msdb).
Andy
July 7, 2003 at 9:40 am
I dont have the .doc with me - it's around 60 articles, covers a bit of everything, perf/admin/dts/etc.
We're definitely hoping it will become an annual project. Only other thought we...
July 7, 2003 at 9:16 am
July 7, 2003 at 4:16 am
At a higher price point, look at Brio, Cognos, Business Objects.
Andy
July 7, 2003 at 4:14 am
You can definitely get it by running a trace. Why can't you kick them out of db_owners? Developers have no business making changes on a production box, definitely shouldn't be...
July 7, 2003 at 4:13 am
Viewing 15 posts - 1,936 through 1,950 (of 6,216 total)