SQL Server 2000 and object owner

[Dennis Redfield]

Does viso for EA support anthing other than dbo as an object owner in
database modeling? I can not get Visio to create a table with anything
other than dbo as the "owner". is this a problem or is it just me?

 

[Scot Becker]

Hi Dennis,

Does viso for EA support anthing other than dbo as an object owner in
database modeling? I can not get Visio to create a table with anything
other than dbo as the "owner". is this a problem or is it just me?

VEA doesn't support any other object owners than dbo.

If you generate DDL script (as opposed to using the wizard) you can always
do a find/replace....

Scot.
................................................
Scot Becker

Orthogonal Software
www.orthogonalsoftware.com

ORM Blog: www.objectrolemodeling.com

To e-mail me, please use my first name at the domain listed above. All mail
sent to the reply-to address gets routed to a junk e-mail folder where it
will likely be deleted without being read.

 

[Juan Miguel Lavista]

Dennis apparently there is a bug when visio only can reverse engineer
dbo objects, and can't work with other objects. The problem is how
visio works with the MS SQL SERVER Stored procedure sp_Mshelpcolumns.
I found this in a google group a fix to this issue

http://groups.google.com/[email protected]

But I could not make it work.
About your question if its possible to create a table with a owner
different from dbo, I don't think so, what I'm doing is after I create
the ddl I run a find/replace to change the owner, but the problem is
(because of visio bug), ones I change the owner visio cannot read
those tables anymore.

 

[Dennis Redfield]

thanks for confirming bug. This has a big impact since none of our tables
are dbo owned and you will be seeing a larger impact when we move to SQL
Server 2005 and owned schemas. Wonder what will happen then....
dlr