Viewing 15 posts - 38,986 through 39,000 (of 39,456 total)
Thanks, I thought I was missing something. I'll add that to my list of items like:
ID10T
PEBKAC
Steve Jones
November 8, 2001 at 10:51 am
November 8, 2001 at 10:48 am
According to this document:
http://www.netopia.com/equipment/pdf/manuals/r3100/isdnref.pdf
you cannot do this. In chapter 11 it states that exported services can only map 1 server per port.
SQL Server only supports one port per instance, so...
November 8, 2001 at 10:48 am
Haven't seen much use of this option. Theoretically, it should speed things up. Are you sure the reporting tool is setting this for all queries? Have you run Profiler to...
November 8, 2001 at 9:55 am
Chris, I think this is a typo. I'll contact Raul and check.
BTW, what's a 1334 trick?
Steve Jones
November 8, 2001 at 9:54 am
When you upgrade, the db remains in 65 compatibility mode. TOP was not a valid tsql statement in 65. Change the mode of the db or use SET ROWCOUNT 10...
November 8, 2001 at 9:53 am
November 8, 2001 at 9:52 am
Can you connect via sql auth?
What versions of server/clients are you using?
In v6.5, you had to connect via named pipes for nt auth.
Check that your clients are all setup the...
November 8, 2001 at 9:51 am
DTS is the easiest. You could probably make BCP work, but not worth it.
You can "save as" from Query Analyzer in csv, but then would need to open in dbase...
November 8, 2001 at 9:50 am
sorry for the typo: map the port.
Let me get this straight: You have 3 SQL Servers, correct? You want to be able to administer them all remotely (externally through the...
November 8, 2001 at 9:48 am
Glad it worked, Jon.
One thing that I do: write out your sql using response.write. Then cut and paste into Query Analyzer to check for syntax errors.
Steve Jones
November 8, 2001 at 8:57 am
Thom,
you could most the port for the other servers (using Server Network Utility). Alternatively, you ought to be able to map 14331 externally and port that back to 1433 to...
November 8, 2001 at 8:55 am
yes. by default, SQL listens on port 1433, so you need to be able to get through this port.
I wouldn't "open this port" to everyone. Just your iis ip.
Steve Jones
November 8, 2001 at 8:53 am
Interesting. Never approached this limit (max about 5000 users). I think that above the 16k limit is where groups are stored.
I'll do some checking and try to get back to...
November 8, 2001 at 8:52 am
What type of workstations? For most newer systems, MS has gone to the MDAC which includes OLEDB rather than ODBC. Hoever, my v6.5 NT4 systems could connect to SQL 7...
November 8, 2001 at 8:50 am
Viewing 15 posts - 38,986 through 39,000 (of 39,456 total)