MS-SQL Database Query (Advanced)

This project requires that you document the internal auditing configuration of both Microsoft SQL 2000 and 2005, and provide the associated queries that would be used to monitor the audit data being collected on a periodic basis looking for the latest entries into audit-related tables. The goal is not to provide specific application auditing, or table auditing at a row and field level, but rather to provide a classic audit trail of user access (logon, logoff, logon failure) and administrative access/use such as configuration change, user/rights management, database/table creation or DDL manipulation - that sort of security auditing. All scripts/commands used to enable and report on the auditing are considered the "source code" of this project, and need to be accompanied by sufficient documentation to instruct basic IT professionals (not DBA's) in their proper use. I've uploaded a zip file that contains the information that was gathered for Oracle. We're looking for the same type of information for MS-SQL. Hopefuly, this will provide a blueprint for the MS-SQL project. The Book "Implementing Database Security and Auditing" by Ron Ben Natan (ISBN: 1-55558-334-2) is effectively the "specification" for this project. If you can get your hands on this book, this may also help you complete the project. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform Windows Server (2000/2003). Microsoft SQL 2000 and 2005