Viewing 15 posts - 35,641 through 35,655 (of 39,720 total)
search at the top menu bar.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 21, 2003 at 11:10 am
Server | Properties | Security Tab. Choose login auditing level.
As far as password changes, no auditing as far as I know of.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 -...
November 21, 2003 at 11:09 am
No issues, the authentication works fine. The big thing is your applications must support it.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 21, 2003 at 11:06 am
no issues here. part of our server standards.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 21, 2003 at 11:04 am
I believe you can remove it if there are no virtual files. You'd need to shrink that file to 0 before you could remove it.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server...
November 21, 2003 at 11:02 am
Actually SQL should reset the permissions properly assuming you use EM and you have the permissions to set permissions.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 21, 2003 at 11:02 am
Interesting idea. The site is undergoing some change and we're testing some things. Adding a full text in the scripts is something we'll add to the list.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of...
November 21, 2003 at 11:01 am
Not sure there is one.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 20, 2003 at 12:28 pm
tempdb only needs it's own drive if there is contention. Slowness and lots of tempdb activity. You can use perfmon to look at transacitons/sec, etc. for the databases.
To separate the...
November 20, 2003 at 12:27 pm
sp_dropserver tmp-prod
sp_addserver prod, local
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 20, 2003 at 12:25 pm
shouldn't
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 20, 2003 at 12:25 pm
I don't recall this being mentioned with Yukon. MS has seemingly gone back to the "scale up" strategy. There was a vendor that was building hardware boxes that would split...
November 20, 2003 at 10:35 am
It's really up to you. The tools will always be on the C drive unless you hack the registry. It doesn't really matter where the program files are stored since...
November 20, 2003 at 10:32 am
That's what I thought. I'd guess PSS can help you, but there would be a charge.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 20, 2003 at 10:27 am
Wow, great question. I'll try to dig around a little, but my impression is that these are fired like this:
check constraint
rule
PK
FK
trigger
Rules are an old feature, only one per column and...
November 20, 2003 at 9:43 am
Viewing 15 posts - 35,641 through 35,655 (of 39,720 total)