Hi. I've got a few SQL query files that I wrote and want to execute on MS SQL Server.
These statements contain comments before each SQL QUERY telling me in rough English what the Query is attempting to do.
What I want to occur when I execute one of my SQL query files is the following:
All commands (both comments and the SQL statements) are echoed to the log file as each query statement is executed, and then the resutls for that query also echoed/spooled to the log file.
So far, I can only get the first 3 lines of the top of each file to "echo" to the spool file.
Any help appreciated, welcomed.
Roger
These statements contain comments before each SQL QUERY telling me in rough English what the Query is attempting to do.
What I want to occur when I execute one of my SQL query files is the following:
All commands (both comments and the SQL statements) are echoed to the log file as each query statement is executed, and then the resutls for that query also echoed/spooled to the log file.
So far, I can only get the first 3 lines of the top of each file to "echo" to the spool file.
Any help appreciated, welcomed.
Roger