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

    Get Name of Person Who create table

    Hi,

    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

    http://forums.databasejournal.com/showthread.php?t=34188

  • #503727
    Hi,

    Check this link.

    http://www.answermysearches.com/sql-server-how-to-get-the-owner-of-a-table/311/

    Thanks

  • #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

    Thanks,
    Asif Huddani

  • #503736
    SELECT su.name FROM
    sysobjects so JOIN sysusers su
    on so.uid = su.uid
    where so.name 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...

    Thanks,
    Asif Huddani

  • #503743
    Hi

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

    http://www.sqlservercentral.com/articles/Advanced/understandingobjectownership/1966/

    Thanks -- Vijaya Kadiyala
    http://www.DotNetVJ.com
    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.

    Cheers,
    Venkatesan Prabu .J
    http://venkattechnicalblog.blogspot.com/


  • 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.