0

A vendor provided a script to run with many DML statements and i dump this in a stored procedure to run it from SQL job. When running the script via SSMS, it returns affected row counts after going through each DML statements such as "update". How can i quickly get the row counts to appear in SQL job step or dump to a text file via job step without setting using @@rowcounts after each of the DML statements?

1

Use SQLCMD through a cmdexec jobstep, instead of TSQL step.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.