Larry Clark is a Microsoft technology specialist in Austin, Texas. He is an MCTS and focuses on databases and development tools. Larry started working with Access, SQL Server, and Visual Basic in 1994.
Help meet compliance goals by using SQL Trace, SQL Server Profiler, and C2 audit mode. View stored procedure examples that demonstrate audit logging with these features, and take a brief look at SQL Server 2008 auditing and third-party options.
Common Criteria Compliance is an advanced configuration option available in SQL Server 2005 SP1 (SP2 is under review). Government, military, financial, and other entities with serious security needs may require its certification and implementation.
Third-party transaction-log analyzers and gateways can audit logs and process and filter SQL Server traffic. They can analyze backup logs and use listener agents to collect and process SQL Server traffic to filter out the good stuff.
Microsoft seems to be bent on marginalizing SQL Server Standard Edition—both in the sense of the artificial constraints placed upon how much memory it can use, and in terms of what seems to be a shift in focus on the role of Standard Edition from Microsoft....More