Results 1 to 3 of 3
  1. #1
    Join Date
    May 2006
    Posts
    6

    Unanswered: How can I log DDL?

    Hallo,

    in Oracle I use DDL-Trigger. But how can I document/triggering DDL (for instance "alter table") in Microsoft SQL Server?

    Regards, Doreen

  2. #2
    Join Date
    Feb 2003
    Location
    India
    Posts
    216
    which version of SQL server are you using? DDL triggers are introduced in SQL Server 2005.

  3. #3
    Join Date
    May 2006
    Posts
    6
    I have to create a history of tables. Therefore I must know the previous structure of the table. I have to document the changes of the structures of the tables.
    Is there a solution for the version 2000?

Posting Permissions

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