SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    \m/ R.I.P. Dimebag! \m/ JimBolla's Avatar
    Join Date
    Dec 2001
    Location
    erie, pa
    Posts
    1,130
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    tracking database schema changes

    I am using SQL 2000 and would like to somehow track/log changes made to the database schema (e.g. create/alter/drop on stored procedures, tables, views, etc) the most ideal situation would be if i could log all the changes including the actual change commands but even i could only get what and when objects were changed, that would be ok. the ideas i've come up with include logging all activity via SQL profiler, or putting a trigger on the sysobjects table in the DB (although i tried this and it told me permission denied)

    if anyone has any ideas or suggestions, that would be greatly appreciated.

  2. #2
    \m/ R.I.P. Dimebag! \m/ JimBolla's Avatar
    Join Date
    Dec 2001
    Location
    erie, pa
    Posts
    1,130
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    ok well i figured out how to track the changes using a trace in SQL profiler. but this still requires me to have profiler running. now i'm trying to get the trace to run as a SQL Agent job, but so far its not quite working. anyone have any experience with running SQL traces via a stored procedure or Job?


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •