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?  89 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 this blog post, let’s have an insight on how Auditing can be done in SSIS packages? The basic auditing in package includes measures like How many rows were inserted, updated or de...
  • Hi SQL Geeks, Here are the blog posts by Piyush Bajaj for the month of May. We would expect more of his informative blogs this month. Happy Learning! If you like our blogs do like us on Facebook at ht...
  • Hi SQL Geeks, Here are the blog posts by Ahmad Osama for the month of May. We would expect more of his informative blogs this month. Happy Learning! If you like our blogs do like us on Facebook at htt...
  • Hi Friends, Are you facing any issue on SQL Server 2014 while running the same query which is running fine on previous version of SQL Server? If answer is yes then this may be due to the change in SQL...
  • I have written a SQL Server Change Data Capture GUI interface to facilitate for CDC operations. The project is hosted here https://sqlcdcapp.codeplex.com/ . Feel free to download, review and suggest c...
  • Recently I came across an interesting deadlock scenario I wasn’t aware off. I didn’t have idea that foreign key constraint can also result in deadlocks. The detailed steps to replicate the...
  • 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. ...