Viewing 15 posts - 38,986 through 39,000 (of 39,466 total)
November 9, 2001 at 9:47 am
You might try installing the SQL Tools on one workstation and seeing if that works. If so, I think the MDAC/ODBC drivers might be out of date, though they should...
November 9, 2001 at 9:45 am
I disagree especially for the sensitive access. Sooner or later that special person will change and having a role makes that more secure. If you use AD or integrated security,...
November 9, 2001 at 8:36 am
Adam,
Is the server NT? I don't think that there is a problem with the revisions being slightly off unless you are trying to make ADO calls (like MDX) that are...
November 8, 2001 at 3:06 pm
Provides a little protection by introducing single user mode.
You could just use sp_renamedb.
Steve Jones
November 8, 2001 at 2:48 pm
Creating the foreign merely requires that the parent key exist before the child can be inserted.
I can have:
Company
CompanyID Company
--------- -------
1 ...
November 8, 2001 at 2:46 pm
Few things I noticed, still looking: sysxlogins uses a varbinary to store the sid. therefore there is no
real limit here.
In sp_addlogin, the sid is generated using NEWID(), which doesn't...
November 8, 2001 at 2:44 pm
What versions and types of clients?
the other workstation may not be on the same domain.
Steve Jones
November 8, 2001 at 2:23 pm
November 8, 2001 at 11:43 am
yes. it is a cisco (not sure of the model), but there is a Linux box behind it that functions as a firewall and provides the port mapping.
Sorry I can't...
November 8, 2001 at 11:40 am
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
Viewing 15 posts - 38,986 through 39,000 (of 39,466 total)