Viewing 15 posts - 2,581 through 2,595 (of 6,216 total)
Dont see where connection pooling will matter to you one way or the other.
Andy
February 6, 2003 at 4:58 pm
Thats a lot of updates. Considering moving distribution db to separate server? Replicating stored proc is a good idea, will save a lot on the publisher - think about what...
February 6, 2003 at 4:57 pm
Not bad. What access level needed for the function - BOL didnt specify any that I saw. If its sysadmin, you'll get some push back!
You'd also have to look at...
February 6, 2003 at 4:49 pm
Interesting idea. Whats the difference between this and just running a hot spare? No performance lag while the spare gets up to speed?
Andy
February 6, 2003 at 4:44 pm
We've got the hardware now for the cluster/san now, just need time to train for it and get it installed. Should be interesting to see!
Andy
February 6, 2003 at 3:10 pm
Start by seeing if replication created triggers on the subscriber tables? Is DTC running?
Andy
February 6, 2003 at 5:26 am
What is generating the key? If you use a data type of uniqueidentifier, duplicates are never supposed to happen since a guid is some combination of network mac address, date/time,...
February 6, 2003 at 5:25 am
February 6, 2003 at 5:22 am
I dont see a way to do it directly - strange, probably there somewhere and Im just not seeing it! You can do it the hard way, something like the...
February 5, 2003 at 5:11 pm
Permission issue maybe? Alternative might be to use sp_oa~ procs to do it via automation.
Andy
February 3, 2003 at 12:58 pm
Not sure exactly what you need. You can use local variables, but because the trigger is a set operation and not a single row, you have to code so that...
February 3, 2003 at 12:54 pm
Considered formatting and reinstalling everything?
Andy
February 3, 2003 at 12:51 pm
Can you ping the server over the VPN? If not, try adding an entry to hosts.
Andy
February 3, 2003 at 12:43 pm
Havent ever looked into it, I know there are some registry flags you can set to tweak behavior, to what extent Im not sure of.
Andy
February 3, 2003 at 11:23 am
Never heard of it. You deserve extra credit for the ipecac thing.
Andy
February 3, 2003 at 10:11 am
Viewing 15 posts - 2,581 through 2,595 (of 6,216 total)