script to check object ownership

• ishaan99

  SSCertifiable

  Points: 6261

  More actions

  August 4, 2004 at 11:02 am

  #161861

  Does anyone have any script that would show me all objects owned by a specific user in a database .

  any help will be greatly appreciated

  TIA 

• hoo-t

  SSChampion

  Points: 12713

  More actions

  August 4, 2004 at 1:18 pm

  #517710

  Try this...

  declare @user sysname

  set @user = 'dbo'

  select so.[name], so.xtype, su.[name]

   from sysobjects so

   join sysusers su

   on so.uid = su.uid

   where su.[name] = @user

  -- Steve