Descending index is not supported in the SQL/Sybase server
From: Ellen (Ellen_at_discussions.microsoft.com)
Date: 02/08/05
- Next message: rmooers: "Aviation graphics"
- Previous message: Lori Pearce \(MSFT\): "Re: Std. Ed. Needs More"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 8 Feb 2005 12:59:04 -0800
I received the information and question below regarding an error generating a
DDL. The version of Visio is Enterprise 2000. I have been unable to find
any information on this problem. Any suggestions would be appreciated. Is
this a driver issue?
The only problem I've run into when trying to generate DDL from a model is
it doesn't support descending indexes. If you uncheck the checkbox on the
indexes tab in the 'Indexed columns' section and then generate the DDL, this
error pops up:
'P2100: 'tblname': Descending index is not supported in the SQL/Sybase
server. The index will be created in ascending collation sequence.'
I am thinking that Visio is generating SQL Server 7.0 syntax and not SQL
Server 2000 syntax since I've seen 7.0 on the Title bar when you try to
create the DDL for a database. I haven't been around SQL Server long enough
to know whether SQL 7.0 allowed descending indexes or not.
Can you check with Visio and see why they don't allow that in the generation
of DDL (I have MS SQL Server as my driver). Perhaps we just need a new
driver? (MS SQL Server 7.0 is pretty old, so they should have it updated by
now.)
- Next message: rmooers: "Aviation graphics"
- Previous message: Lori Pearce \(MSFT\): "Re: Std. Ed. Needs More"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
