>>>I have bulk records that are getting imported into a SQL Server 2005 table. I need to be able to maintain the same order that they were imported. I was using a DateTime field and populating it to GETDATE(), but that wasn't precise enough.
>>>
>>>Any advice out there?
>>
>>In SQL Server 2005 there is no date types with high precision. There are several in SQL Server 2008 (DateTime2).
>
>Any other ideas? I received a recommendation elsewhere to rely on the autoincrementing identity column, but I've always believed that to be bad practice.
Check last suggestion from this thread
http://social.msdn.microsoft.com/Forums/en/transactsql/thread/3db0d9c8-7fe5-4adf-80df-7ee76da891c2
If it's not broken, fix it until it is.
My Blog