Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 252
  • Last Modified:

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
0
d_potts
Asked:
d_potts
  • 4
  • 3
1 Solution
 
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
 
Kevin3NFCommented:
sysobjects will not tell when an object was ALTERed or by whom
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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
 
Kevin3NFCommented:
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
 
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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now