Viewing 15 posts - 3,196 through 3,210 (of 6,216 total)
Yes, they do take additional resources. On the other hand, making round trips to retrieve the value takes resources too. Curious as to why you picked the 50k limit?
Andy
September 22, 2002 at 8:22 pm
This article may help:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql7/html/proxyrep.asp
Andy
September 22, 2002 at 3:13 pm
No:-) Couple different layers here, will explain to the extent that I understand! First layer is the transaction within the publisher. Log reader will NOT process it and add it...
September 22, 2002 at 3:10 pm
Try the -querytimeout switch, set to a value in seconds. You probably should also enable the -OutputVerboseLevel switch with a setting of 2, have to provide a path & file...
September 22, 2002 at 2:45 pm
The default is 1433 but its common for it to be different. One reason is to try to provide a small bit of extra security, the other is if you...
September 22, 2002 at 11:52 am
September 22, 2002 at 11:50 am
First try stopping and restarting the log reader. If that doesnt work try stop/start SQL Agent. You can also try extending the timeout for the log reader (not the best...
September 22, 2002 at 3:41 am
Havent spent much time on collations. I use the default case insensitive, in some cases might make a column case sensitive. Not that this answers your question, but why do...
September 21, 2002 at 10:18 am
Bad sector on the disk, wrong permissions, not enough file space?
Andy
September 21, 2002 at 10:16 am
Take a look at this thread:
Andy
September 21, 2002 at 10:15 am
Damn you snitz! Gotta love it. We havent decided, but we are looking at asp.net alternatives.
Anyway, we do like filling the gap where we can. Sometimes we know the answer,...
September 21, 2002 at 9:11 am
I just meant that while I recommend you do your transactions either in TSQL directly (or maybe COM+ if that is a better fit) you can make the support for...
September 19, 2002 at 10:55 am
I think the QA option is to disconnect isnt it? Can you give an example of when you'd get results and then not want them?
Andy
September 19, 2002 at 10:49 am
September 19, 2002 at 10:46 am
I think you need both the FTP and SQL port open. Opening SQL port is not a great idea. You can apply the snapshot manually and avoid the SQL port...
September 19, 2002 at 6:22 am
Viewing 15 posts - 3,196 through 3,210 (of 6,216 total)