Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Vamshi527
Starting Member
1 Post |
 Posted - 2010-08-13 : 07:48:28
|
| 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 |
|
|
|
|
|
SORT_IN_TEMPDB,DROP_EXISTING - index creation