8 Feb
2007
8 Feb
'07
2:04 p.m.
Hi, in order to let the MSSQL sripts work I had to do these mods: - First of all the scripts work only on SQL 2005, due to the "var(max)" function which was introduced with this latest version - Changed "system_user" in "system_user2", as suggested on OTRS site - the otrs-schema-post.mssql.sql script has been heavily modded. - Since script otrs-schema-post.mssql.sql gave some errors on foreign keys I had to modify Two tables: table "standard_attachment" column "id" changed from "smallin"t to "int" table "auto_response" column "id" changed from "smallin"t to "int There will be 3 messages following with the corrected scripts. Hope this helps. Best regards Dave