Viewing 15 posts - 3,211 through 3,225 (of 6,216 total)
Thats right. Its a transaction like any other.
Andy
September 19, 2002 at 6:19 am
Agree. You could try to piece it together by finding the jobs related to the plan and scripting them, not quite the same as having a script that will repro...
September 19, 2002 at 6:16 am
If its not too long, post the code here, or you can add to the script library.
Andy
September 19, 2002 at 6:13 am
Thanks! DMO isnt always the answer of course, but good to know your options (and have some examples).
Andy
September 19, 2002 at 5:17 am
That's correct. Typically used to make a view updatable that otherwise would not be.
Andy
September 18, 2002 at 8:21 pm
Ah well. Still, no reason you cant make it work using ADO. You'll have to correlate statements in Profiler with whats happening in your code, see why the connection is...
September 18, 2002 at 8:15 pm
Probably transactional or merge. Hard to say why in a paragraph, or even a page. You have to look at table size, transaction volume, if you'll be doing updates in...
September 18, 2002 at 7:04 pm
You could perhaps parse out the DSN, but even then it might be an alias. Try @@servername or look at serverproperty.
Andy
September 18, 2002 at 2:40 pm
Have not. Figure its probably one extra packet back to the client plus a bit of server side tracking.
Andy
September 18, 2002 at 2:38 pm
What cursor location/model you using? Have you considered just doing the transaction in the stored proc and not using ADO to handle it?
Andy
September 18, 2002 at 2:37 pm
One con is "complexity". Replication isnt rocket science, but it does add a layer to things. Another is licensing and hardware. You'll have to buy more of each for your...
September 18, 2002 at 2:35 pm
I think I'd also begin profiling to see what is happening. Start with a general trace for a day or two, look for the heavy hitters. After that you might...
September 18, 2002 at 2:31 pm
September 18, 2002 at 4:55 am
September 18, 2002 at 4:48 am
Nope. Have to do it a bit differently:
odb = oserver.Databases.Item("Pubs")
Andy
September 17, 2002 at 3:52 pm
Viewing 15 posts - 3,211 through 3,225 (of 6,216 total)