Determine who owns objects other than dbo

• richarar

  SSC Rookie

  Points: 45

  More actions

  March 20, 2003 at 10:13 am

  #58610

  How do I determine what objects are owned by users other than dbo. Our developers have created objects with there own user name because they do not have dbo. I have changed what I can find, but I am still missing an object that is not owned by dbo. I am trying to drop all my users, but I can't because they still own objects.

• Chris Hedgate

  One Orange Chip

  Points: 25041

  More actions

  March 20, 2003 at 11:06 am

  #451600

  select * from sysobjects where uid <> 1

  --

  Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

  http://www.sql.nu

  --
  Chris Hedgate http://www.hedgate.net/
  Contributor to the Best of SQL Server Central volumes
  Articles: http://www.sqlservercentral.com/columnists/chedgate/

• mybid2003

  SSCertifiable

  Points: 6620

  More actions

  March 21, 2003 at 11:25 am

  #451725

  With the following query you can better idea what objects and who is the owner:

  <pre id=code><font face=courier size=2 id=code>

  select so.name, so.uid, su.name

  from sysobjects so,

  sysusers su

  where so.uid <> 1

  ANDsu.uid=so.uid

  ORDER by su.name

  </font id=code></pre id=code>

  Hope this Helps!!!

  .

• richarar

  SSC Rookie

  Points: 45

  More actions

  March 21, 2003 at 11:57 am

  #451733

  Thanks....