var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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]
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]
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.
ur codings are working excelent.