MS SQL Server - Activity Captured by profiler

Author

Activity Captured by profiler

Double_B

2006-02-28, 8:23 pm

Hi

Does the profiler catch every activity on the server. I mean what about
the various username & password screens , dont you think then its a
threat to security .

& I wanted to knw how to get the last 10 SQL Statments issued by the
users client to the SQL Server.

dbcc inputbuffer (spid) gives us the last statement how to get a
history of statments by a SPID.

Thanks

John Bell

2006-02-28, 8:23 pm

Hi

Profiler will not display sensitive data such as passwords etc. If you are
worried about passwords and usernames you should also use protocol encryption
between client and server.

You can use a filter in profiler to restict information display to a given
SPID or use the search options to jump between entries for a given SPID.

John

"Double_B" wrote:

> Hi
>
> Does the profiler catch every activity on the server. I mean what about
> the various username & password screens , dont you think then its a
> threat to security .
>
> & I wanted to knw how to get the last 10 SQL Statments issued by the
> users client to the SQL Server.
>
> dbcc inputbuffer (spid) gives us the last statement how to get a
> history of statments by a SPID.
>
>
> Thanks
>
>

Sponsored Links