Home Forums SQL Server 2008 SQL Server 2008 - General Msg 2715, Level 16, State 7, Line 2 Column, parameter, or variable #4: Cannot find data type varchar(50) RE: Msg 2715, Level 16, State 7, Line 2 Column, parameter, or variable #4: Cannot find data type varchar(50)

  • April 20, 2018 at 4:09 pm

    #1987770

    ejoell 66477 - Friday, April 20, 2018 8:26 AM

     But why would the auto-generated script show the square brackets in the incorrect location?

    It wouldn't.

    However, if the autogenerated script correctly contained [int] and you did a search/replace replacing "int" with "varchar(50)", then you will end up with [varchar(50)]

    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