Any Way to Determine Which User Created the Table? 1

[JohnBates]

Hi,

I think I'm out of luck on this one but why not ask anyway?

I have several programmers in a Windows domain group called
GMWebDev. On SQL Server (2000), GMWebDev has db_owner Database Role.

So tables created by one of these programmers shows owner as 'dbo'.

Is there any way, maybe a system table, that might give me a clue as to the actual device/host or user that created the table ?

Thanks, John

 

[mrdenny]

We actually just talked about this here thread962-935235.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[JohnBates]

thanks mrdenny, and to SQLSister for the other post you referred me to.

This group does NOT have sysadmin rights, but by being db_owner, I'm out of luck as for finding the actual creator (who is using the nvarchar data type even though I have asked them not to 100 times !)

John

 

[SQLSister]

Well you could send an email to all developers telling them the next time anyone uses nvarchar, they will all lose their table creation priviledges until someone fesses up.

Questions about posting. See faq183-874

 

[mrdenny]

That works. Nothing works quite like laying down the smack.

Denny

--Anything is possible. All it takes is a little research. (Me)