Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Invalid object name 'sys.spt_values' RE: Invalid object name 'sys.spt_values'

  • September 19, 2013 at 9:53 pm

    #1651753

    Jeff Moden (9/19/2013)

    I don't have 2k12 to confirm but try dbo.spt_values instead of sys.spt_values.

    I just tried and that works as long as you're in [master]. (If not, you just have to make it [font="Courier New"]master.dbo.spt_values[/font])

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]