Viewing 15 posts - 1 through 15 (of 24 total)
What is the deny step for BuiltIn\Administrators (T-SQL), or SSMS? Can you give me
specific example of what you've done?
April 21, 2010 at 8:35 am
When I setup my custom Profiler trace, which Events should I select to help pin down what the application is doing? (I'm listing all events to see what I...
March 3, 2010 at 8:43 am
Believe it or not, I've tried all the other ones aside from sysadmin. The applications do not work properly with any of them. I'm still researching this with...
March 2, 2010 at 11:30 am
March 2, 2010 at 11:24 am
What is the command to STOP the trace once it has started running?
March 1, 2010 at 2:25 pm
What and where is this tool/function?
February 26, 2010 at 11:26 am
While we are on the topic of SQL Server instance Logins, I have another question.
My SSIS service Logins for two separate SQL Server instances are set to:
February 22, 2010 at 12:29 pm
A question I have is this about removing BUILTIN\Administrators from Security->Logins on SQL Server  instance.
If I remove this account from Logins, but the domain users remain as Local\Administrator on...
February 22, 2010 at 9:40 am
Third party application. I have no idea what the app is doing. It is hitting TempDB more than infrequently though.
February 12, 2010 at 11:16 am
I have no control over it. It is simply an operation that is executed with certain application activities. I'm not sure what the final result is.
My question is...
February 12, 2010 at 6:15 am
The SQL DBEngine, Agent and Configuration Manager have already been installed on C: drive. I'm doing a later install of the Tools (BOL, SSMS, etc.).
I was not given the...
February 9, 2010 at 10:23 am
What is query to run to ensure default trace NOT disabled, and to determine where it would be located. One of my SS instances did NOT have a Log...
February 5, 2010 at 2:59 pm
So I would have to run a Profiler Trace 7 x 24 if I need to capture that metadata for all security-type events (login, logout, connections, etc.)?
We are running an...
February 5, 2010 at 11:19 am
Do you have a draft copy? I'd love to have a peak at your handiwork on such a doc.
Zee - General Dynamics, Atlanta GA
January 21, 2010 at 1:07 pm
Thanks John, this will help me document the System Security Plan on this issue.
Zee - Atlanta, GA
January 21, 2010 at 11:53 am