>I have a SQL Server table that has 7 indexes defined. When I do a simple select
>statement from the query analyzer without using ORDER BY the results of the query come back in the order of the 4th index defined. Is there a way to define
>an index as primary in SQL server either with a command or using the enterprise manager ?
Only ORDER BY can guaranty the order of the records in the result set.
--sb--