Viewing 15 posts - 39,241 through 39,255 (of 39,717 total)
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
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
Viewing 15 posts - 39,241 through 39,255 (of 39,717 total)