Viewing 15 posts - 2,986 through 3,000 (of 6,216 total)
I see quite a few postings in the MS groups, didnt see an answer. Have you checked for blocking on both servers?
Andy
October 29, 2002 at 11:18 am
Hey Ramsudha_r! Have never tried it, seems like it should be possible but not sure. No 6.5 install to test with and have to admit no enthusiasm for installing it...
October 29, 2002 at 11:15 am
I dont have a script, usually done in VB code, at least part of it. What we do is try to standardize the address by converting Street to ST, Avenue...
October 29, 2002 at 11:10 am
I ran into a similar issue doing a file import, first time I would get a collation error, but if I did a resume it worked fine. Documented bug in...
October 28, 2002 at 6:34 pm
Gotta love the photons in the cable. Might be true I suppose...
Andy
October 28, 2002 at 6:32 pm
Not generally a good idea to run on the same server. Still, thats an interesting problem. Do you get anything in the event log? SQL error log?
Andy
October 28, 2002 at 6:08 pm
No idea. OLAP is a different world! We're weak in that area, if you learn the answers please drop by to answer some questions:-) Be interested to hear which book...
October 28, 2002 at 6:07 pm
Why use MySQL if you have the SQL box doing nothing?
Andy
October 28, 2002 at 6:04 pm
If you're using ADO loop through the ADO errors collection. Sometimes the error messages you get from VB/SQL are less than thrilling.
Andy
October 28, 2002 at 6:04 pm
Never tried it. Curious why you need to do this? I know thats not helping much!
Andy
October 28, 2002 at 6:03 pm
October 28, 2002 at 6:01 pm
I agree that using replication does take some additional horsepower - how much is hard to quantify. For transaction, you can kind of picture the server workload by thinking about...
October 28, 2002 at 5:59 pm
Thanks to all who've posted. Pleasantly surprised by the reeeption, mentioning Access on a SQL site is usually a recipe for tar and feathers:-)
Andy
October 28, 2002 at 5:53 pm
Cant disagree that having users issuing direct updates is...well, less than optimal? In my case these users are reasonably well trained and are taught to be cautious. In last two...
October 28, 2002 at 7:54 am
If the app is doing it you should see a second (or more) spid. If SQL is using parallel execution you'll have multiple lines in sysprocesses with same spid, different...
October 28, 2002 at 7:49 am
Viewing 15 posts - 2,986 through 3,000 (of 6,216 total)