Results 1 to 2 of 2

Thread: MSSQL install Error creating acl_roles

  1. #1
    Kabutotx is offline Junior Member
    Join Date
    Dec 2011
    Posts
    6

    Default MSSQL install Error creating acl_roles

    A brand new install to SQL Server. Got an error Incorrect sytax 'max' creating acl_roles.

    Incorrect syntax near 'max'.. : CREATE TABLE acl_roles (id varchar(36) NOT NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id varchar(36) NULL ,created_by varchar(36) NULL ,name nvarchar(150) NULL ,description nvarchar(max) NULL ,deleted bit NULL ) ALTER TABLE acl_roles ADD CONSTRAINT pk_acl_roles PRIMARY KEY (id) CREATE INDEX idx_aclrole_id_del ON acl_roles ( id, deleted )

  2. #2
    Kabutotx is offline Junior Member
    Join Date
    Dec 2011
    Posts
    6

    Default Re: MSSQL install Error creating acl_roles

    Doesn't run on SQL Server 2000. SQL Server 2008R2 is working fine.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. New MSSQL install fails on acl_roles
    By Kabutotx in forum Installation and Upgrade Help
    Replies: 3
    Last Post: 2011-12-09, 02:27 AM
  2. Error creating table: fields_meta_data: (install issue)
    By eeau1973 in forum Installation and Upgrade Help
    Replies: 2
    Last Post: 2008-04-28, 02:46 PM
  3. SugarCE 5.0 IIS5 XP Pro MSSQL Install error
    By wdtanner in forum Installation and Upgrade Help
    Replies: 0
    Last Post: 2007-12-21, 07:58 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •