query all objects by user

• kc-282439

  SSC Journeyman

  Points: 80

  More actions

  March 19, 2006 at 9:51 pm

  #171702

  hey, im a sql noob, and had a question for you experts!

  i was wondering if it was possible to create a query which would get me all of the objects created by a particular user.

  thanks, and please, if i could be any clearer, just let me know!

• kc-282439

  SSC Journeyman

  Points: 80

  More actions

  March 20, 2006 at 2:41 pm

  #627724

  k, found out that one can put this into query editor:

  select * from sysobjects where uid =user_id(user_name())

• alexia-294642

  SSChasing Mays

  Points: 600

  More actions

  March 22, 2006 at 7:17 pm

  #628261

  try this ....

  declare @name sysname

  set @name = 'yourUserDB'

  select * from dbo.sysobjects

  where uid = (select uid from master.dbo.sysusers

  where name like @name)

   

  cheers......

  alexia