Specifying SQL Server 2005 database schema

[cseha]

If I specifiy the database schema for SQL Server 2005 tables as the tagged value 'OWNER', everything is correctly qualified in the generated DDL, but the sp_addextendedproperty @level0type contains 'User', so when the DDL is executed I get the 'Object is invalid. Extended properties are not permitted on 'TableName', or the object does not exist.' error message.
I have to replace 'User' to 'SCHEMA' in order to make it work.

Is there a better way to specify the database schema for SQL Server 2005 tables?

Thanks,
Attila

[Elham]

USER and TYPE as level-0 types will be removed in a future version of SQL Server. Avoid using these features in new development work, and plan to modify applications that currently use these features. Use SCHEMA as the level 0 type instead of USER. For TYPE, use SCHEMA as the level 0 type and TYPE as the level 1 type.
(FROM BOOK ONLINE)

[Ed Vowles]

I have this problem too. Did you get a work around cseha?

As Elham points out, the USER level-0 type is on the way out and really we want enterprise architect to set SCHEMA as the level-0 type.

How do you specifiy the database schema for sql server 2005/2008 tables??!

Ed

[cseha]

Unfortunatelly I don't know a better way to specify the schema.

The work around: find and replace 'User' -> 'SCHEMA'

But the issue still exists.

[«Midnight»]

Make a feature request - or better yet a bug report, since SQL Server 2005 and 2008 make it clear that the old syntax should not be continued.

Use the appropriate link under the Support link near the bottom of any forum page.

[edit]See below.

Sparx has this in hand.[/edit]

[juhi]

We already aware of this issue. The appropriate fixes will be availabale in our next release. From our next build, 'USER' keyword will be generated only for SQL Server 2000 and SCHEMA will be generated for SQL Server 2005 and 2008. Sorry for the inconvenience.

  Juhi
Sparx Systems Pty Ltd