LearnItFirst User Forum

Welcome Guest

Search | New Posts | Members | Log In | Register

SQL Server Forum - LearnItFirst.com » SQL Server Scripts, Code Samples and SSMS Custom Reports » SQL Server 2005/2008 » using SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF in SQL Server 2000

using SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF in SQL Server 2000

Options

Previous Topic · Next Topic

vamshikrishna.527

Posted: Friday, August 13, 2010 7:09:10 AM

Rank: Newbie

Joined: 8/13/2010
Posts: 1
Points: 3
Where do you live?: Indi

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

Scott Whigham

Posted: Friday, August 13, 2010 7:36:08 AM

Rank: Super Mod

Joined: 3/20/2006
Posts: 476
Points: 1,053
Where do you live?: Dallas, TX

Yes the" = OFF" part is not in 2000: http://msdn.microsoft.com/en-us/library/aa258260%28SQL.80%29.aspx

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.