Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 A quckie

Author  Topic 

BruceT
Yak Posting Veteran

78 Posts

Posted - 2011-03-08 : 18:23:13
Is there a way to tell what user created a table?

Thanks

namman
Constraint Violating Yak Guru

285 Posts

Posted - 2011-03-08 : 21:17:30
Right click on the db -> reports -> schema change history

Go to Top of Page

pk_bohra
Master Smack Fu Yak Hacker

1182 Posts

Posted - 2011-03-08 : 22:19:30
Other ways:
select create_date,* from sys.tables where name ='yourtablename'

select create_date,* from sys.objects where type ='U' and name ='yourtablename'
Go to Top of Page
   

- Advertisement -