Post reply

Conversion failed because the data value overflowed the data type used by the provider.

  • August 1, 2018 at 9:22 am

    #1999896

    I had never seen this error before and have been working with SQL Server for 19 years. Today I created a view on a table and subsequently changed the data type on one field of that underlying table from int to varchar(50). That caused this error to occur when I attempted to query the view across a linked server.  I could see from the definition of the view that it still maintained the "int" datatype for the table column I had altered.
    Solution was to drop the view and recreate it.

  • August 1, 2018 at 12:22 pm

    #1999930

    dtcalif - Wednesday, August 1, 2018 9:22 AM

    I had never seen this error before and have been working with SQL Server for 19 years. Today I created a view on a table and subsequently changed the data type on one field of that underlying table from int to varchar(50). That caused this error to occur when I attempted to query the view across a linked server.  I could see from the definition of the view that it still maintained the "int" datatype for the table column I had altered.
    Solution was to drop the view and recreate it.

    sp_refreshview should update the metadata for the view definition.

    Sue

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

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