Finding the Owner

bmains · July 29th, 2004, 03:21 PM

Hey,

I want to research who put a table into a database well after the fact (created 2003). Does SQL Server store that metadata somewhere?

Thanks,

Brian

bmains · July 29th, 2004, 03:23 PM

Oh, and this question assumes that auditing is off...

alyeng2000 · July 30th, 2004, 02:15 AM

sp_help tablename

Ahmed Ali
Software Developer

Jeff Mason · July 30th, 2004, 08:24 AM

Quote:

quote:Originally posted by alyeng2000
sp_help tablename

Ahmed Ali
Software Developer

Of course, this merely lists the table's owner, e.g. 'dbo' and not at all necessarily the user that created it.

But I don't think you are going to do any better than this - I don't think the system keeps the sort of information you are looking for...

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

happygv · July 31st, 2004, 08:16 AM

Hi Brian,

This gives you the Owner of the object.

Code:

select Sysusers.Name 
from Sysusers, Sysobjects 
where Id=object_id('<TABLE_NAME>') 
    and Sysobjects.Uid = Sysusers.Uid

As Jeff said, one cannot go beyond that to find who really created it.

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

bmains · August 3rd, 2004, 08:42 AM

Hello,

OK, thanks for the information.

Brian