• NBD4K27 (9/6/2007)


    That was what I originally thought; however,I saw one of our servers had some trace files in the defualt location and thenInoticed one trace file in a different location then the default I also noticed that the modified date was today so I know for sure that the location can indeed be changed.

    HELP PLZ <img src='images/emotions/sad.gif' height='20' width='20' border='0' title='Sad' align='absmiddle'>

    You cannot change the location where the C2 audit trace files are written. The other trace files you're seeing must be from another trace running on your server.

    References:

    http://connect.microsoft.com/SQLServer/feedback/details/669702/c2-audit-files-location

    http://technet.microsoft.com/en-us/library/ms187634.aspx

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato