Viewing 15 posts - 38,101 through 38,115 (of 39,720 total)
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
March 1, 2002 at 1:55 pm
np, however since there was already a response in the other one, I left it there.
If I get a chance, I'll move it here.
Steve Jones
March 1, 2002 at 1:54 pm
What about non-clustered index? It will also help. What type of queries? Can you post a sample.
Steve Jones
March 1, 2002 at 11:38 am
Viewing 15 posts - 38,101 through 38,115 (of 39,720 total)