Viewing 15 posts - 4,096 through 4,110 (of 6,216 total)
Bob, my hats off to you - thats an excellent tip - embarrased I didnt think of it myself!
Andy
June 4, 2002 at 4:31 pm
I'd be surprised. More likely that it would be an issue trying to run SQL on a XP box than connect to one.
Andy
June 4, 2002 at 2:21 pm
The best way is to post the results from the error log after turning on trace flag -1204. Without seeing that I'd guess its happening due to your index plan,...
June 4, 2002 at 1:40 pm
I'd confirm connectivity - make sure you can ping the server you're trying to connect to.
Andy
June 4, 2002 at 1:37 pm
One thing to do is make absolutely certain no one is making changes to the subscriber (unless you intend to have updating subscribers) while you troubleshoot. Then I'd recommend profiling...
June 3, 2002 at 6:36 pm
I came across this link, might be helpful:
Andy
June 3, 2002 at 6:33 pm
Unless you have a really good reason, I'd leave them. They are used to help the query optimizer work better.
Andy
June 3, 2002 at 6:33 pm
Probably better off trying to enforce this in your app, just have the trigger do the logging. You could then run a job against that table to look for instances...
June 3, 2002 at 5:31 pm
Lots of ways. You could loop through them using the file system object, open an ado connection, use a stream object to load them. You might also look at the...
June 3, 2002 at 4:00 pm
Deadlocks can be hard to find. It's based on the order the info (or the index)is accessed. You can turn on trace flag 1204 to get some additional information about...
June 3, 2002 at 3:59 pm
First and last are not supported in TSQL. Aside from that you can do group by, sum, avg, etc, with no problem. Conceptually it may help you to create a...
June 3, 2002 at 3:55 pm
Not that I know of. With SQL2K you could use an instead of trigger, thats about the only way I know. Beyond that you could maybe figure out what was...
June 3, 2002 at 3:52 pm
We use asp for a lot of minor apps, and for stuff that has to be externally accessible by clients. Internally for large apps we have a process in place...
June 3, 2002 at 12:40 pm
I'll skip the ASP vs VB discussion, but I'd like to hear why the installs were a problem with VB? I find that using MSI for deployment I have almost...
June 3, 2002 at 12:04 pm
Viewing 15 posts - 4,096 through 4,110 (of 6,216 total)