• I need this for logging in a multiprocess, multithreaded environment.

    I understand that the CPU does other things but even when I have multiple callers call the logging SP (I have one field in the DB with a default getdate() ) I can not break the 14 or so ms barrier.

    The second example does not show the getdate() granuality but the DATETIME granuality. I am wondering if the gatdate() inherently can not handle the full spectrum of DATETIME values.

    Do you have access to a fast PC that you could run this test and see if on a faster machine you get better then the 14 ms?

    The one I am using right now is a single core 2.13GHz

    ---------------------------------------------
    [font="Verdana"]Nothing is impossible.
    It is just a matter of time and money.[/font]