diagram object behavior in EM

Dear Collective Wisdom,
Noticed something odd back when we first upgraded to XP in that when one
goes to view an existing relational diagram object for a database in
Enterprise Manager, everything appears blank in the diagram. New
diagrams, OTOH, can be created and viewed without any problem. Any ideas?
Thanks in advance!
gms--
Maybe this link will help you:
http://www.yiapap.com/bldiagra.htm
Cristian Lefter, SQL Server MVP
"Greg M. Silverman" <gmsRE@.MOVEumn.MEeduAT.COM> wrote in message
news:d48i5q$1m8$1@.lenny.tc.umn.edu...
> Dear Collective Wisdom,
> Noticed something odd back when we first upgraded to XP in that when one
> goes to view an existing relational diagram object for a database in
> Enterprise Manager, everything appears blank in the diagram. New
> diagrams, OTOH, can be created and viewed without any problem. Any ideas?
>
> Thanks in advance!
>
> gms--
|||Cristian Lefter wrote:
> Maybe this link will help you:
> http://www.yiapap.com/bldiagra.htm
> Cristian Lefter, SQL Server MVP
Thanks for the link... I did find this also info in the depths of
Technet, have yet to try it.
gms--

> "Greg M. Silverman" <gmsRE@.MOVEumn.MEeduAT.COM> wrote in message
> news:d48i5q$1m8$1@.lenny.tc.umn.edu...
>
>
|||Greg M. Silverman wrote:
> Cristian Lefter wrote:
>
> Thanks for the link... I did find this also info in the depths of
> Technet, have yet to try it.
>
> gms--
>
Ok, just did it and it worked!
Thanks!
gms--

Determining Object Ownership

How do I determine the ownership of an object? (i.e. table)
SELECT USER_NAME(OBJECTPROPERTY(OBJECT_ID('table_name'),' Ownerid'))
Thanks
Yogish

Determining Object Ownership

one way... to get the owner of the AUTHORS table...
Bruce
SELECT name from sysusers
where uid = OBJECTPROPERTY(OBJECT_ID
('authors'),'OwnerID')

>--Original Message--
>How do I determine the ownership of an object? (i.e.
table)
>.
>
Another way... Open up EM and look at the "owner" column...
Thanks,
Mike C
"Bruce de Freitas" <bruce@.defreitas.com> wrote in message
news:39e401c51f64$0ea67db0$a401280a@.phx.gbl...[vbcol=seagreen]
> another way...
>
> select TABLE_SCHEMA as 'owner'
> from information_schema.tables
> where TABLE_NAME = 'authors'
>
>

Determining Object Ownership

one way... to get the owner of the AUTHORS table...
Bruce
SELECT name from sysusers
where uid = OBJECTPROPERTY(OBJECT_ID
('authors'),'OwnerID')

>--Original Message--
>How do I determine the ownership of an object? (i.e.
table)
>.
>Another way... Open up EM and look at the "owner" column...
Thanks,
Mike C
"Bruce de Freitas" <bruce@.defreitas.com> wrote in message
news:39e401c51f64$0ea67db0$a401280a@.phx.gbl...[vbcol=seagreen]
> another way...
>
> select TABLE_SCHEMA as 'owner'
> from information_schema.tables
> where TABLE_NAME = 'authors'
>
>

Determining Object Ownership

How do I determine the ownership of an object? (i.e. table)SELECT USER_NAME(OBJECTPROPERTY(OBJECT_ID('tabl
e_name'),'Ownerid'))
Thanks
Yogish

Determining Object Ownership

How do I determine the ownership of an object? (i.e. table)one way... to get the owner of the AUTHORS table...
Bruce
SELECT name from sysusers
where uid = OBJECTPROPERTY(OBJECT_ID
('authors'),'OwnerID')
>--Original Message--
>How do I determine the ownership of an object? (i.e.
table)
>.
>|||another way...
select TABLE_SCHEMA as 'owner'
from information_schema.tables
where TABLE_NAME = 'authors'
>--Original Message--
>one way... to get the owner of the AUTHORS table...
>Bruce
>SELECT name from sysusers
> where uid = OBJECTPROPERTY(OBJECT_ID
>('authors'),'OwnerID')
>
>>--Original Message--
>>How do I determine the ownership of an object? (i.e.
>table)
>>.
>.
>|||SELECT USER_NAME(OBJECTPROPERTY(OBJECT_ID('table_name'),'Ownerid'))
--
Thanks
Yogish|||Another way... Open up EM and look at the "owner" column...
Thanks,
Mike C
"Bruce de Freitas" <bruce@.defreitas.com> wrote in message
news:39e401c51f64$0ea67db0$a401280a@.phx.gbl...
> another way...
>
> select TABLE_SCHEMA as 'owner'
> from information_schema.tables
> where TABLE_NAME = 'authors'
>
>
>>--Original Message--
>>one way... to get the owner of the AUTHORS table...
>>Bruce
>>SELECT name from sysusers
>> where uid = OBJECTPROPERTY(OBJECT_ID
>>('authors'),'OwnerID')
>>
>>--Original Message--
>>How do I determine the ownership of an object? (i.e.
>>table)
>>.
>>.