[otrs] OTRS and MS SQL Server

[COSTA Dave - Lievitalia S.p.A.]

Hi, anyone experimenting with SQL Server?

Still trying to link the ms DB to OTRS...

Thank you.

Dave


-----Original Message-----
From: otrs-bounces at 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/

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 3234 bytes
Desc: not available
Url : http://lists.otrs.org/pipermail/otrs/attachments/20070213/7ed32a77/attachment-0001.bin