Home Forums SQL Server 2005 Administering Error Message: String or binary data would be truncated. RE: Error Message: String or binary data would be truncated.

  • You can't. You just run a trace a trace using the Standard Template (be sure to include the TextData column for the RPC completed event) and add filters on Database ID, and for application like Microsoft SQL Server Management Studio.

    Attached is a zip file with a template. You just need to change the filter on DatabaseID. Put the template in C:\Documents and Settings\[your user name here]\Application Data\Microsoft\SQL Profiler\9.0\Templates\Microsoft SQL Server\90 and it will show up in Profiler.

    Once you have profiler running, open SSMS connect to the DB and do an update. YOu should find and RPC:Completed event with TextData like sp_execute_sql 'Update statement', 'Parameter Defintion', Paramter list.