How do I start up 'SQL Profiler'?

Can it be used to get information from an application query using SQL Server 2008 such as table Name, column etc. In short can you display the SQL that was run to develop a screen from an external application. Apllication name is Xytech

How do I start up 'SQL Profiler'?

Can it be used to get information from an application query using SQL Server 2008 such as table Name, column etc. In short can you display the SQL that was run to develop a screen from an external application. Apllication name is Xytech

Hi JR,
Profiler is the tool which comes as a part of product (other than express edition) and installed when we install client tools. If the stored procedure code is not encrypted then you would be able to see the statement being executed in SQL Server. Note that it won't replace and show the variable values in profiler.