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