Remove Object Ownership

• shree

  Say Hey Kid

  Points: 702

  More actions

  May 19, 2009 at 9:31 am

  #130403

  I Found that dropping the user from database , erroring out like cannot delete the user because the objects owned by the user.

  i could not figureout what are those objecrs dependent on the user.i did not find tables. stored procedures,defaults

  still i am missing it.

  can some one give idea where can i look for it or can provide kind of script run through all objects in the database.

• Adam Wilbur

  SSCertifiable

  Points: 7001

  More actions

  May 19, 2009 at 10:49 am

  #997164

  I think this will get you what you need unless I am misunderstanding the issue.

  select * from sys.objects o

  inner join sys.schemas s on o.schema_id = s.schema_id

  where s.name = 'NameOfSchemaInQuestion'

  
  
  A.J.
  DBA with an attitude