I have stored procedure that runs as a job and it has started failing giving me an error of "String or binary data would be truncated. [SQL STATE 22001] [Error 8152] The statement has been terminated [SQLSTATE 01000] [Error 3621]. The step failed. I am trying to run a trace on the stored procedure because when I execute the sp in query analyzer it works fine. When I run a trace I do not get any results I would appreciate any help on setting me up a trace to troubleshoot this error. Thanks
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.