>When I do a insertion of a record I want to save not only the Timestamp like "HH;MM;SS" but I also want to store the microsecond part, since in 1 second a machine can store mulitple records, ant I want to distinguish them by milli or microsecond.
Check
http://www.karaszi.com/SQLServer/info_datetime.asp#DtFormatsInput - in SQL Server 2008 you can have better precision using datetimeoffset type
If it's not broken, fix it until it is.
My Blog