Viewing 15 posts - 37,831 through 37,845 (of 39,456 total)
March 4, 2002 at 4:22 pm
Can you post what you tried alogn with some more sample data. Not entirely sure what you mean. Also include the table DDL.
Steve Jones
March 4, 2002 at 4:21 pm
I understand that with the SQL login you can determine who the person is, join this to some table and allow them to "retrieve" the file. Makes sense. Personally, I'd...
March 4, 2002 at 2:38 pm
March 4, 2002 at 2:34 pm
The only thing I can think of is generate a single columns as
select firstname + char(13) + middle + char(13)...
Steve Jones
March 4, 2002 at 1:17 pm
What's "a lot" of traffic. Have done this and not seen substantial overhead.
Steve Jones
March 4, 2002 at 1:12 pm
You have to rename the sql server. use sp_dropserver, sp_addserver with the LOCAL option to do this.
Steve Jones
March 4, 2002 at 1:08 pm
March 4, 2002 at 10:24 am
Been working with SQL for ten years. You can make a living, of course, you can do that in most any area. I live in Denver and commented on the...
March 4, 2002 at 10:20 am
March 4, 2002 at 10:12 am
The main thing is that changes to system tables, even querying system tables, is unsupported. If you have an issue and MS finds out, you get no support, zero, nada,...
March 4, 2002 at 9:57 am
The biggest problem with NT auth is the ports required. These are often blocked by firewalls (for good reasons).
We have made trusted connections from a web server to a...
March 4, 2002 at 9:45 am
Not to prop myself, but I think this is a good summary:
http://www.sqlservercentral.com/columnists/sjones/wp_encryption.asp
Also another view:
http://www.sqlservercentral.com/columnists/NWeicher/securityworstpracticeneil.asp
Steve Jones
March 4, 2002 at 9:39 am
What you could do is make some esimate of how long it takes for the deadlock to appear, then every xx minutes, remove older information from your profiler table. This...
March 4, 2002 at 9:14 am
Thanks, and actually I've got about 8 of these on all different topics. I've been compiling them over the last 3-4 months and will be releasing them one by one....
March 4, 2002 at 9:01 am
Viewing 15 posts - 37,831 through 37,845 (of 39,456 total)