Hi, anyone experimenting with SQL Server? Still trying to link the ms DB to OTRS... Thank you. Dave -----Original Message----- From: otrs-bounces@otrs.org on behalf of COSTA Dave - Lievitalia S.p.A. Sent: Thu 08/02/2007 15.04 To: User questions and discussions about OTRS.org Subject: R: [otrs] OTRS and MS SQL Server 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 _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support orr consulting for your OTRS system? =http://www.otrs.com/