Hi vinothd;

basically the script does two things, it creates a trace on the server; server side traces do not have an appreciable impact on the server.

second, it creates a view so that you can review the results of the trace. simply do a

SELECT * FROM sp_DMLTrace

to see the whole trace, and then start adding WHERE statements to limit the rows you see and the specific transactions you want to review.