• bbop1322 (7/30/2010)


    ... I now know where to create them at both the Server and Database level but cannot determine where to configure the synchronicity at. Can someone point me in the right direction?...

    Brian, at http://msdn.microsoft.com/en-us/library/cc280448(SQL.100).aspx, it explains that setting the QUEUE_DELAY property to 0 causes the audit to run synchronously, anything higher causes it to run asynchronously. The default (and minimum non-zero value) is 1000 ms.