Descending index is not supported in the SQL/Sybase server

E

Ellen

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.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Descending index not supported in the SQL/Sybase server. 0
Forward Engineer Visio ER Diagram to SQL DDL 2
Error P1023 datatype bit is not allowed to have index (SQL2K SP3) 0
"Refresh Model" wizard creates duplicate unique indexes (SQL Serve 0
generating sql script from diagram 1
Reverse Engineering SQL Server 2005 database using Visio 2003 3
Dates don’t work within WHERE clauses 2
Connect to SQL Server 2005 2

Top