Home Forums SQL Server 2008 SQL Server Newbies i copy scripts from msdn then run at sqlserver 2008 r2 with sp3 ,report error RE: i copy scripts from msdn then run at sqlserver 2008 r2 with sp3 ,report error

  • April 14, 2016 at 10:28 am

    #1872074

    Using copy/paste from your post, I tried the query on my database (which is SQL Server 2012, so not the same version) and it ran without error.

    Can you repost the complete error message using copy/paste from the error window? (I see some typos in the error message so I assume you typed it here instead of using copy/paste).

    When you double-click the error message, what line in the query window is highlighted?

    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/