Post reply

print command

  • February 24, 2004 at 4:01 am

    #178221

    with the print command a value or variable is returned on the screen at a certain point in a statement, is there a way of forcing the print statement to populate a text file for logging purposes

     

  • February 24, 2004 at 5:17 am

    #495277

    No. You could try inserts to a logging table or use sp_oa... items to call and talk to a text file to write data to (creates a high failure point thou as if it fails it rolls back). What is your hope to accomplish.

  • February 24, 2004 at 6:46 am

    #495294

    the purpose is to have a log file record of the steps parsed in a TSQL statement so that a record is kept of the process, this way there is a tangible file of what a successful run should be so that comparisons can be made without having to watch query analyser. ISQLW goes part of the way with the output switch but the detail is not good enough, i need it to record text that I want in the file, so that i have a benchmark log file.

    thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply