How to audit when statements such as Create Procedure are executed

Question

How to audit when statements such as Create Procedure are executed

DBADave

SSChampion

Points: 10962
More actions
April 19, 2006 at 10:34 am

#117039

Is it possible to create an alert that would run when a statement has been executed such as:
CREATE DATABASE
CREATE PROCEDURE
CREATE TABLE
CREATE VIEW
BACKUP DATABASE
BACKUP LOG
I want to audit when these commands are executed, but I don't want to do this through profiler, unless you feel the overhead would not be noticeable.
Thanks, Dave

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Antares686 SSC Guru Points: 125444 More actions · Answer 1

Assuming you are using SQL 2000 you could always setup a trace via the stored procedures or purchase another app such as ProAcitve http://www.whitesands.com/Home/home.htm which is a packet sniffer and has less overhead than Profiler but needs to be run at the server.

noeld SSC Guru Points: 96590 More actions · Answer 2

OR upgrade to SQL 2005 and create a simple DDL trigger

* Noel

Lowell SSC Guru Points: 323546 More actions · Answer 3

all of the log trolling software that is advertised here have the ability to identify and report against DDL changes as well.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

homebrew01 SSC Guru Points: 55553 More actions · Answer 4

We have Lumigent Log Explorer that also can send alerts for those types of activities.