[ http://jira.undersunconsulting.com/browse/OFBIZ-188?page=comments#action_13935 ] Marco Risaliti commented on OFBIZ-188: --------------------------------------
Someone knows if it is still an issue and it has been solved ? Thanks Marco > Alter Table syntax for MS-SQL server incorrect. > ----------------------------------------------- > > Key: OFBIZ-188 > URL: http://jira.undersunconsulting.com/browse/OFBIZ-188 > Project: [OFBiz] Open For Business > Type: Bug > Components: entity > Versions: SVN > Environment: Database update on startup and webtools database update > Reporter: BJ Freeman > Assignee: Jira Administrator > > Original Estimate: 5 hours > Remaining: 5 hours > > ofbiz send this > ALTER TABLE dbo.CREDIT_CARD RENAME CARD_NUMBER TO TMP_CARDNUMBER > MS SQL server sytax does not support Rename. > ALTER TABLE dbo.CREDIT_CARD ALTER COLUMN NullCOl NVARCHAR(20) NOT NULL > is the sytax to change column size. > will check code anb provide patch soon. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://jira.undersunconsulting.com/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
