Kathi,

What is the deny step for BuiltIn\Administrators (T-SQL), or SSMS? Can you give me

specific example of what you've done?

Thanks,

Zee,

Atlanta

Mike,

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...

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...

Thanks Steve.

Zee Atl

Lowell,

What is the command to STOP the trace once it has started running?

Thanks,

ZeeAtl

Accidental DBA

Steve,

What and where is this tool/function?

Zee

Kathi,

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:

...

Kathi,

A question I have is this about removing BUILTIN\Administrators from Security->Logins on SQL Server [2005] instance.

If I remove this account from Logins, but the domain users remain as Local\Administrator on...

Third party application. I have no idea what the app is doing. It is hitting TempDB more than infrequently though.

Thx,

Zee

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...

Andrew,

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...

Craig,

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...

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...

Jack,

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

🙂

Thanks John, this will help me document the System Security Plan on this issue.

Zee - Atlanta, GA