Forum Replies Created
Viewing 15 posts - 6,001 through 6,015 (of 6,105 total)
-
RE: e-mail attachments & centralised db server
It sounds like your files are being kept on the filesystem and not as BLOBs. Is this correct? As Andy asked, what does SQL Server do in this configuration?
K....
-
RE: NT4 stays alive
Yes, indeed. I think the realization that many who were MCSEs had not completed recertification (myself included) would not do so by Dec 31 finally caused them to relook...
-
RE: SQL2000 - Replication within Clusters
Just so we're on the same page (using 2 servers, extrapolate for more)...
Active/Passive - 2 servers, 1 actively responding to requests addressed to the virtual server, the other in standby...
-
RE: Procedure headache
quote:
the prob is that the proc is deleting the recs but not inserting it into the archives tableOctober 6, 2001 at 12:07 am
-
RE: Locking in Tranactions
This is a particularly alarming statement:
quote:
I have a stopred prodedure with a transaction in it , which includes some static and dynamically... -
RE: Best Practices on the Web
If you're following Microsoft's recommended security document (assuming you're using IIS), your IIS box basically doesn't talk via UDP and you limit the TCP ports to what the web server...
-
RE: copy data to SQL Server by checking (available)
When you say you'd like to mix the two queries, I'm thinking you want to take all the rows in SQL Server that aren't found in the progress database and...
-
RE: timeout expired
Also, how are you configured to talk to that server from the client? Named Pipes or TCP/IP? Make sure in Client Network Utility that TCP/IP is set higher...
-
RE: What are certification benefits???
Here in the US, though, certification isn't a guarantee of skill. We saw a trend where the bootcamps were getting very successful at training people to pass the exams,...
-
RE: Storing large variables
For the first part, a string > 4000 characters, you've always got the option of the text data type.
As for union, the sort is going to be on...
-
RE: Monitoring where server down
We don't have any of the commercial packages, so I ended up writing a DTS job that checks once an hour for servers in a given list. It tries...
-
RE: SQL 2000 in a shared web hosting environment
About the only thing I've found that even comes to close doesn't really. However, you may have a look at the operations guide:
K. Brian Kelley
-
RE: varchar type
I believe the limitation in 6.5 for varchar was 255. It increased to 8000 in version 7.0. So you can't explicitly increase the varchar size past the limit.
K....
-
RE: Selecting the n'th to the n'th + x set of rows
That's what it must be. I think I'm still on SP1.
K. Brian Kelley
-
RE: Selecting the n'th to the n'th + x set of rows
Yup. My goof. My brain processed ROWCOUNT because he wanted n rows.
K. Brian Kelley
Viewing 15 posts - 6,001 through 6,015 (of 6,105 total)