Write the output of a delete stored procedure to output file

• Jessica-240533

  SSC Eights!

  Points: 879

  More actions

  April 2, 2007 at 10:57 am

  #116364

  Hi,

  I have a stored procedure running as a scheduled task that deletes rows from a particular table. I tried in the step, outputing the results to a file to see if it would tell me how many rows are deleted but it does not. Is there anyway for me to output the number of rows deleted to a flat file?

   

  Thanks,

  Jessica

• OriginalWHY

  Mr or Mrs. 500

  Points: 524

  More actions

  November 6, 2007 at 4:23 am

  #748581

  Hi

  You can do a print on the count to the file

  Edit the code to have a @varible to the count the PRINT it

  regards