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!
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
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply