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 |
|
Noel4001
Starting Member
1 Post |
 Posted - 2007-08-14 : 09:02:54
|
| I am new to SQL 2000 and was wondering if it is possible to drop a table and keep the trigger?We are recreating the table shortly after it is dropped but want to keep the triggers to attach to the newly created table. We are moving data from database to another database. There is a third party app that is why we recreate the table. The third party app that assigns the trigger to the table when it is origianlly created using its interface, but not when we move data via the SQL engine. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-08-14 : 09:18:21
|
| when you drop the table the trigger gets dropped too.you can script your triggers and run them after the move..._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
|
|
|
Drop Table Keep Trigger