View object is lost without a trace

• zach_john

  SSCertifiable

  Points: 5922

  More actions

  August 4, 2009 at 9:48 am

  #203426

  Trying to understand how a view could be dropped and not be captured as a DDL schema change.

  I'm thinking maybe a dependancy change but I don't see anything on those tables either.

  See attached history any thoughts appreciated.

  
  John Zacharkan

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  August 4, 2009 at 10:08 am

  #1034372

  No attachment.

  Do you have a DDL trigger defined that should have caught this and didn't?

  You should have a row in the Default Trace for this. IT would show as an Obect:Deleted event.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question

• zach_john

  SSCertifiable

  Points: 5922

  More actions

  August 4, 2009 at 10:47 am

  #1034412

  wierd about the attachments.

  We do run traces and this definitely something we keep track of which is why I was lost on how i could have missed a dropped. Mystery has been solved.

  The only other way this could happen is if the database was restored from another source and that source doesn't contain the view.

  I did the question on recent restored, the answer was no and i took that for gospel; next time I won't trust what I'm hearing and I'll just look myself

  Thanks for your time.

  
  John Zacharkan