You CREATE TRIGGER [TRIGGER NAME] ON [dbo].[AddressMenuItems] FOR INSERT, UPDATE, DELETE [choose one of those]. AS ... That's the syntax, and it is prompted by the SQL Server when you create a new trigger. There is no such thing as "Trigger FOR" without either INSERT / UPDATE or DELETE. I hope that helps. Best Bigfootguy

When you install MSDE, the installation is unattended (or silent), rather than interactive. I need to specify collation, but it does not allow me to do it, installing instead the default which is no good for me. How can I select (or change) a collation in MSDE? Thanks. Best Bigfootguy

OK now. The error was in Scheduling a Job: the Step should have been of type Operating System Command (CmdExec), NOT Transact SQL Script (TSQL), as the DTS package itself is ActiveX VB Script. The problem has been resolved. Best Bigfootguy

- Create a DTS Package that will run that SQL statement ( ->Data Transformation Services -> Local Packages ) - Schedule it to run at designated time / interval ( ->Management ->SQL Server Agent ->Jobs ) Best Bigfootguy

Guys, We've got a problem. There is a DTS package which polls for a file and puts it into a ..\Processing directory. It is written as an ActiveX Script. It refuses to run as a scheduled job. However, if you execute it, it runs perfect. There are no other jobs running that would interfere with this one. Indeed, no other jobs running even close to that time at all. To add to this: when you look in the job history, it always shows that the job failed - even when you manually run it and it is in fact succesful. We have tried to delete the DTS and the job and re-create them from scratch. However, the same problem persist. We would not like to re-create the DTS package and the job under a different name (that worked before for other problem, BUT: it would break the standards, as over 100 clients have that DTS installed and scheduled, and it works fine with them!) Is that a Microsoft bug or something? It looks like somewhere it has recorded that this package name does not work! Any help is appreciated. Best Bigfootguy