SQL Server: How to query for DDL changes from the default trace when no DDL auditing has been configured on the database

Who is online?  146 guests and 0 members
home  »  blogs  »  Vasudev Menon  »  SQL Server: How to query for DDL changes from the default trace when no DDL auditing has been configured on the database
  Rate This Blog Entry:  register  or  login

Author

Vasudev.Menon Vasudev Menon (Member since: 4/26/2011 5:00:57 AM)

View Vasudev Menon 's profile

Comments (3)

Sachin.Nandanwar
4/28/2011 5:46:33 AM Sachin Nandanwar said:

Hi Vasudev,

Its a great tip but the problem is that it wont give the details of the exact changes that happened overtime on an object.

by
Vasudev.Menon
4/29/2011 5:24:28 AM Vasudev Menon said:

Yes Sachin, It does not provide with the detailes of the changes made. But the saving point was, the engineer responsible for the change was identified, proof presented to the concerned engineer on the date and time of change made and was requested to update the change process documents to reflect the changes made

by
Marko
8/25/2011 6:48:36 PM Marko said:

Can this be modified to include earlier trace files?

by

Leave a comment

Name:
  *  
Email:  (your email is kept secure)
 *  
Website:

example: "http://www.SQLServerGeeks.com"

 
Type the characters:
 *
 
   

SQLServerGeeks FaceBook group

SQLServerGeeks Events

Training on Microsoft Products & Technologies

Email Subscriptions

   Get the Most Recent Blogs in your inbox
Blogs RSS Feed

Vasudev Menon's latest blog posts

Blogs RSS Feed

Latest community blog posts

  • Hi Friends, In my earlier blog, I just explain about the importance of filtered indexes. Link for that blog is mention below: http://sqlservergeeks.com/blogs/princerastogi/personal/599/filtered-indexe...
  • A few words about the technology of our site. It's easy to take technology for granted, to focus on content and pay no attention to how it is being delivered. Typically we would encourage this focus. ...
  • Hello, Constraints can be defined as rules that govern the values that are inserted into a column. These rules help in enforcing data integrity. For example if a NOT NULL constraint is defined over a ...