Viewing 15 posts - 37,876 through 37,890 (of 39,498 total)
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
more secure than a file system? It shifts the control from the db to the admin, but the access control is the same.
Steve Jones
March 2, 2002 at 10:54 am
This gets asked regularly. There is no way to secure the database from sa.
Steve Jones
March 2, 2002 at 10:40 am
Viewing 15 posts - 37,876 through 37,890 (of 39,498 total)