Post reply

To track the Huge insertions Query?

  • October 1, 2010 at 12:32 am

    #224578

    Dear Experts,

    I am frequently getting this problem,. ie

    Many insertions query in our software having morthan 120 columns,

    while the insertions happening conversions error is happening like varchar to numeric or int etc...

    But our SQl server didnot inform us exact column name, this kind of situations How can we trace the exact column?

    THanks in advance

  • October 1, 2010 at 5:59 am

    #1230132

    Well, you might not be able to, but if you use a stored procedure and match the parameters to the columns in terms of data type, you should be able to eliminate the error.

    Are you using dynamic, application generated TSQL? If so, you'll need to check the code.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply