Home Forums SQL Server 2005 SQL Server 2005 General Discussion How to find the owner of the table in MSSQL 2005? RE: How to find the owner of the table in MSSQL 2005?

  • November 21, 2006 at 11:15 pm

    #673382

    In SQL2005:

    SELECT SCHEMA_NAME(OBJECTPROPERTYEX(OBJECT_ID('yourTablesName'),N'SchemaId'))

    Julian Kuiters
    juliankuiters.id.au