You must Sign In to post a response.
  • Category: SQL Server

    Get Name of Person Who create table


    i am working in team and we all access central server database (SQL SERVER 2008)

    we all login by our individual login name using SQL Server authentication.

    i am administrator and i want to know who create table....

    All people have rights to create table
  • #503716
    refer this

  • #503727

    Check this link.


  • #503729
    Hi, karthekeyan

    I am still not get.. i want to know that if any table create in any database then how to check who create table

    Asif Huddani

  • #503736
    sysobjects so JOIN sysusers su
    on so.uid = su.uid
    where like 'mstVendor'
    and xtype='U'

    sp_table_privileges @table_name='mstVendor'

    sp_tables @table_name='mstVendor'

    i try all above but always give me "DBO" as table_Owner not proper result come...

    Asif Huddani

  • #503743

    Check out the below link to understand how Ownership of the object works in SQL Server.

    Thanks -- Vijaya Kadiyala
    Microsoft MVP

  • #503749
    Try this query you will get all the informations..

    select * from sysobjects where xtype='u'

    By Nathan
    Direction is important than speed

  • #504027
    Microsoft have introduced DDL triggers starting from the version SQL Server 2005.

    You can use it to get the user created these tables.

    Venkatesan Prabu .J

  • This thread is locked for new responses. Please post your comments and questions as a separate thread.
    If required, refer to the URL of this page in your new post.