Home Forums SQL Server 2005 Administering Implicit conversion from data type sql_variant to varchar is not allowed. Use the CONVERT function to run this query. RE: Implicit conversion from data type sql_variant to varchar is not allowed. Use the CONVERT function to run this query.

  • February 20, 2009 at 7:29 am

    #947494

    It means somewhere within that procedure something's trying to convert a sql_variant to varchar.

    Can you post the procedure?

    Why are you using SQL_variants anywhere?

    How are you constructing the parameter list in your front end code? (C#?)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass