Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Gustav
Starting Member
1 Post |
 Posted - 2009-05-27 : 12:21:03
|
| I am using a web harvesting program that on schedule creates a table in SQL server 2008 and populates it with values. The program starts by dropping anyexisting tables with a user-defined table name. Therafter it creates a new table with an identical name and populates it with values.I am trying to create a ddl trigger that will acknowledge that a new table with has been created and thereafter copy the values from this table to another tablethat will not be dropped once the web harvesting program runs again.Is this possible in SQL server 2008?OBS!! the web harvesting program is non-configurable... |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-05-27 : 13:03:42
|
| http://www.sqlteam.com/article/using-ddl-triggers-in-sql-server-2005-to-capture-schema-changes |
 |
|
|
|
|
|
DDL triggers limitations