Hi, anyone experimenting with SQL Server? Still trying to link the ms DB to OTRS...
Thank you.
Dave
-----Original Message-----
From: [EMAIL PROTECTED] 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/
<<winmail.dat>>
_______________________________________________ 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/
