>>As Naomi just said, there's DateTime2....also, you want to populate it using the function SYSDATETIME()
>
>What would be the equivalent of SYSDATETIME() in VB.NET? For now, I use Date.Now.

DateTime.Now doesn't seem to be precise enough :(

http://msdn.microsoft.com/en-us/library/system.datetime(v=vs.110).aspx

See also

http://stackoverflow.com/questions/7119021/sql-server-2008-stored-procedure-with-datetime2


Looks like we need to search for more precise .NET DateTime class.

>
>>I believe DateTime2 goes down to the nanoseconds.
>
>Yes, that is correct.
>
>>Here's a very good article that covers it:
>>http://blog.sqlauthority.com/2010/06/11/sql-server-difference-between-datetime-and-datetime2/
>
>Thanks