To view the contents of a stored procedure in SQL Server profile

Thanks for sharing: http://blog.sina.com.cn/s/blog_7ac076230100qifk.html

When I checked the profile of the database yesterday. Inside there is an EXEC sp_execute 1, ' x ', ' y ', ' z '. And do not see what to do.

Later reference http://topic.csdn.net/u/20080708/14/b857a43b-3718-48a9-993b-ffc9ba43ed40.html

You can modify the profile template, select the Show All events check box in events selection, and then you can see the other options under stored procedure, and select Sp:stmtstarting Or sp:stmtcomplete can see the contents of the stored procedure.

This type of SP is called the system Stored procedures, reference http://msdn.microsoft.com/en-us/library/aa259564

To view the contents of a stored procedure in SQL Server profile