Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2010
    Posts
    1

    Unanswered: Using SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF option in SQL Server 2000

    Hi i am trying to create a index with the following syntax which worked in 2005 SQL server but giving error --- Incorrect syntax near '('. in 2000 db .. PLz help...

    CREATE NONCLUSTERED INDEX [NDX001_MT_ATPAR_TRANSACTION] ON [MT_ATPAR_TRANSACTION]

    (

    [STATUS] ASC,

    [APP_ID] ASC,

    [BUSINESS_UNIT] ASC,

    [USER_ID] ASC,

    [ID] ASC

    )WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]

    GO

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    That syntax is SQL 2005 only. All those settings are the default anyway so you could leave them out of 2005 too and get exactly the same index created.
    CREATE INDEX
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •