Show dynamic SQL from Stored procedure

[zemp]

SQL Server 2000 SP4

Is there a way to show the finished SQL statement from within a stored procedure that dynamically creates it.

Even if all that can be done is to send it to a file.

zemp

 

[SQLDenis]

sure use print and look at the message tab

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
Google Interview Questions

 

[SQLDenis]

example

use pubs 
go


declare @tableName varchar(50), @sql varchar(500)
select @tableName ='orders'
select @sql = 'select * from ' + @tableName


exec(@sql)
print @sql

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
Google Interview Questions

 

[zemp]

Forgive me, but I can't find the message tab that was mentioned. Where is it?

zemp

 

[SQLDenis]

in query analyzer

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
Google Interview Questions