How to insert the print statements from a try catch block into a physical table in sql server.
For example i will have a table called dailyloadlog (date datetime,errormessage, varchar)
how can i get the print statment into the table dailyloadlog
You would alter the CATCH portion to just insert the values from the error.
You could also just select the message out directly without having to assign it to a variable like this,
Hope this helps!