Very simple query. I just need to sort by Index. Used to do this all the time. Whats the deal?
SELECT TOP (1000) [Index] ,[Product] ,[Company] ,[WONum] ,[MatlNum] ,[SealMatlNo] ,[ValveOptions] ,[Misc#] , FROM [Powerapps].[dbo].[SN_Test_DF_Idx_Full2] order by Index asc
Msg 1018, Level 15, State 1, Line 12
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.
Other columns work fine. This has neven been an issue before.