Re: Profiler and user password

From: Jens Süßmeyer (Jens_at_Remove_this_For_Contacting.sqlserver2005.de)
Date: 04/24/05 

Date: Sun, 24 Apr 2005 21:22:21 +0200

Is it possible for profiler to show which password is used when a user logs
> to a sql server

Hehe, no that would be a security leak ;-) there has been an issue on some
providers in 7.0 but its fixed now in those which i know.

> a sql server and the users ip

No, as far as i know there is only the way to get the Hostname, once i wrote
a Function to get the IPAdress, but it was only used in TSQL rather than
profiler.

HTH, Jens Suessmeyer. 

---
http://www.sqlserver2005.de
---
"ET" <ET@discussions.microsoft.com> schrieb im Newsbeitrag 
news:A8858926-8C9C-44A5-9D53-B86369C14DB5@microsoft.com...
> Is it possible for profiler to show which password is used when a user 
> logs
> to a sql server and the users ip ?? If so how.

Relevant Pages

  • Re: Problem altering table and adding a default
    ... SQL Server does not allow that - you can only add nullable ... > After you add a new column in Enterprise Manager, uncheck Allow Nulls, ... the ALTER TABLE statement above will pass to the SQL Server ... > 4) Start Profiler and perform a new trace. ...
    (microsoft.public.sqlserver.server)
  • Re: Running profiler on busy 8-cpu Sql Server
    ... with SQL Server. ... Not only does the Profiler GUI's screen need to ... Server & places it on queues that the Profiler GUI picks up. ... / data columns & filters you define in a profiler trace, ...
    (microsoft.public.sqlserver.server)
  • Re: Problem altering table and adding a default
    ... ALTER TABLE dbo.Test_tbl ADD Notnull_col1 charNOT NULL ... SQL Server does not allow that - you can only add nullable columns. ... After you add a new column in Enterprise Manager, uncheck Allow Nulls, bind the uder- ... Start Profiler and perform a new trace. ...
    (microsoft.public.sqlserver.server)
  • Re: stress by profiler ?
    ... Are you running the Profiler on the same machine as SQL Server? ... The response time of DB access is also good. ... -- very low Disk Read ...
    (microsoft.public.sqlserver.server)
  • Re: Should I Index?
    ... Wayne Snyder, MCDBA, SQL Server MVP ... > A good place to start is the index tuning wizard. ... Use profiler to do this. ... some suitable indexes based on the workload. ...
    (microsoft.public.sqlserver.server)