Chris Lane-152984
SSChasing Mays
Points: 636
More actions
December 19, 2005 at 1:41 pm
#102991
How can I find all objects in all databases on a server that might be owned by a username?
Ninja's_RGR'us
SSC Guru
Points: 294069
December 19, 2005 at 1:44 pm
#610437
Select name, xtype from dbo.SysObjects where uid = 1
1 = dbo
December 19, 2005 at 2:04 pm
#610441
Great thanks.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply