>The only thing I could find was Thread #
370647, which deals with stored procedures for the ID table. I already have these. The ones that I am missing are for the users, groups and usgrlink tables. They are all RI (Referential Integrity) stored procedures. Have you reproduced these in SQL?
>
>Kind Regards,
>
>Mat
Nope. I havn't looked too closely at the RI for these, but it wouldn't be too difficult to recreate the triggers in SQL Server. Unfortunately, SQL Server doesn't support cascading update and deletes so you're forced to do things with triggers. Too complicate matters, triggers that emulate cascading deletes won't fire if you have foreign key constraints. Migrating to SQL Server requires a little bit of getting used to. Also, check your tables to see what kind of null values your fields are set to. The default is set to not accept NULL values when upsizing a database. This can also cause problems.