SQL Catching Create and alter statement

Is there a way to create an application that watches sql server for Alter and Create commands.  All changes done to SQL server databases are done with Integrated Security and I want to track you does what with out a front end 3rd party tool.  From my understanding you would not want to use a trace as it may effect performance.  I am not usre but do alerts catch these ?




I would offer more poiint put this all I have
LVL 2
d_pottsAsked:
Who is Participating?
 
Kevin3NFConnect With a Mentor Commented:
They will be the presenter at the SQL Server user group meeting that I go to in June....not that it will help you now, but I'll ask them what is running under the hood
0
 
Kevin3NFCommented:
I would set it up in a trace but filtered to the databases in question and text data = %Alter% or %create%
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Why don't you query sysobjects table in the database?
I think you have there the information that you want.
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
Kevin3NFCommented:
sysobjects will not tell when an object was ALTERed or by whom
0
 
d_pottsAuthor Commented:
I thought it would be a trace.  I just seen a software package the would monitore SQL server for you and tell you of all the changes and who made them.  It was designed for Sarbanes and Oxly.  We currently do not need that level of detail for SOX at the current moment but I was wondering how the software package did so when It comes time we can deveop a custom application that will suit our needs.
0
 
Kevin3NFCommented:
Care to mention the package name?  Someone here may very well know how it works
0
 
d_pottsAuthor Commented:
0
 
d_pottsAuthor Commented:
that will be great.  I am in no rush for this anyway.  It was just one of those things that I seen I wondered how they were doing that.  At a $1000 a server and in a company with about 20 Sql servers I am sure we could write it cheaper and then we could customize the tool so it works to what ever need we need.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.