Activity Captured by profiler

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.
ThanksHi
Profiler will not display sensitive data such as passwords etc. If you are
worried about passwords and usernames you should also use protocol encryptio
n
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
>