SQL Profiler

Is a wonderfull tool provided by MSSQL. It analysis and provides us with
all the information of what goes on in a SQL Instance.


We could monitor all kind of events like login i.e , failures,diconnections etc,
the Transac-SQL statements, select,insert,update, and delete etc, Start or
end of a stored procdure, Error written to the SQL Server error log,locks