Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Steve Jones CREATE TABLE and Indexes RE: CREATE TABLE and Indexes

  • November 15, 2016 at 5:07 pm

    #1912669

    david.gugg (11/3/2016)

    Oh, I missed the part about this being SQL Server 2016. When I run this on our 2008 R2 instance, I get:

    Msg 1018, Level 15, State 1, Line 5

    Incorrect syntax near 'INDEX'. If this is intended as a part of a table hint, A WITH keyword and parenthesis are now required. See SQL Server Books Online for proper syntax.

    Oh well.

    I got this syntax error also, on an earlier version. Still, I learned something. Thanks for the question Steve.