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 |
|
Incognito
Starting Member
49 Posts |
 Posted - 2001-10-08 : 05:40:36
|
| Hello,I wrote this trigger to execute a DTS package when I update, delete or insert in the table (Copy SQL Server Task Properties):Create Trigger bla bla..EXEC master..xp_cmdshell 'dtsrun Sservername' bla bla...If I run this code(only DTSrun) from the commandshell the package works perfect. But when I try to insert something in Query analyzer or somewhere else(when the trigger comes in action) it blocks itselfs like its in a loop which has no end.I tried several things but I couldn't solve this problem. If you have any suggestions for me, it would be great!ThnxIncognito |
|
|
|
|
|
DTSrun problem