I believe you have to use the new SQL Server 2008 DATETIME2 data type which supports a larger precision, 00:00:00 through 23:59:59.9999999.
Roj
Loading User Information from Channel 9
Something went wrong getting user information from Channel 9
Loading User Information from MSDN
Something went wrong getting user information from MSDN
Loading Visual Studio Achievements
Something went wrong getting the Visual Studio Achievements
I believe you have to use the new SQL Server 2008 DATETIME2 data type which supports a larger precision, 00:00:00 through 23:59:59.9999999.
Roj