I have to list all triggers in SQL Server database with table title and table's schema.

I am almost there with this particular:

SELECT trigger_name = name, trigger_owner = USER_NAME(uid),table_schema = , table_name = OBJECT_NAME(parent_obj),
  isupdate = OBJECTPROPERTY( id, 'ExecIsUpdateTrigger'), isdelete = OBJECTPROPERTY( id, 'ExecIsDeleteTrigger'),
  isinsert = OBJECTPROPERTY( id, 'ExecIsInsertTrigger'), isafter = OBJECTPROPERTY( id, 'ExecIsAfterTrigger'),
  isinsteadof = OBJECTPROPERTY( id, 'ExecIsInsteadOfTrigger'),
  [disabled] = OBJECTPROPERTY(id, 'ExecIsTriggerDisabled') 
FROM sysobjects INNER JOIN sysusers ON sysobjects.uid = sysusers.uid
WHERE type = 'TR'

I simply need to obtain the table's schema also.

Here's one of the ways:

SELECT trigger_name = sysobjects.name, trigger_owner = USER_NAME(sysobjects.uid),table_schema = s.name, table_name = OBJECT_NAME(parent_obj),
  isupdate = OBJECTPROPERTY( id, 'ExecIsUpdateTrigger'), isdelete = OBJECTPROPERTY( id, 'ExecIsDeleteTrigger'),
  isinsert = OBJECTPROPERTY( id, 'ExecIsInsertTrigger'), isafter = OBJECTPROPERTY( id, 'ExecIsAfterTrigger'),
  isinsteadof = OBJECTPROPERTY( id, 'ExecIsInsteadOfTrigger'),
  [disabled] = OBJECTPROPERTY(id, 'ExecIsTriggerDisabled') 
FROM sysobjects INNER JOIN sysusers ON sysobjects.uid = sysusers.uid
INNER JOIN sys.tables t ON sysobjects.parent_obj = t.object_id
INNER JOIN sys.schemas s ON t.schema_id = s.schema_id
WHERE sysobjects.type = 'TR'

EDIT: Said out join to sysusers for query to operate on AdventureWorks2008.

SELECT trigger_name = sysobjects.name, trigger_owner = 'x'/*USER_NAME(sysobjects.uid)*/,table_schema = s.name, table_name = OBJECT_NAME(parent_obj),
  isupdate = OBJECTPROPERTY( id, 'ExecIsUpdateTrigger'), isdelete = OBJECTPROPERTY( id, 'ExecIsDeleteTrigger'),
  isinsert = OBJECTPROPERTY( id, 'ExecIsInsertTrigger'), isafter = OBJECTPROPERTY( id, 'ExecIsAfterTrigger'),
  isinsteadof = OBJECTPROPERTY( id, 'ExecIsInsteadOfTrigger'),
  [disabled] = OBJECTPROPERTY(id, 'ExecIsTriggerDisabled') 
FROM sysobjects /*INNER JOIN sysusers ON sysobjects.uid = sysusers.uid*/
INNER JOIN sys.tables t ON sysobjects.parent_obj = t.object_id
INNER JOIN sys.schemas s ON t.schema_id = s.schema_id
WHERE sysobjects.type = 'TR'

EDIT 2: For SQL 2000

SELECT trigger_name = o.name, trigger_owner = 'x'/*USER_NAME(o.uid)*/,table_schema = s.name, table_name = OBJECT_NAME(o.parent_obj),
  isupdate = OBJECTPROPERTY(o.id, 'ExecIsUpdateTrigger'), isdelete = OBJECTPROPERTY(o.id, 'ExecIsDeleteTrigger'),
  isinsert = OBJECTPROPERTY(o.id, 'ExecIsInsertTrigger'), isafter = OBJECTPROPERTY(o.id, 'ExecIsAfterTrigger'),
  isinsteadof = OBJECTPROPERTY(o.id, 'ExecIsInsteadOfTrigger'),
  [disabled] = OBJECTPROPERTY(o.id, 'ExecIsTriggerDisabled') 
FROM sysobjects o /*INNER JOIN sysusers ON sysobjects.uid = sysusers.uid*/
INNER JOIN sysobjects o2 ON o.parent_obj = o2.id
INNER JOIN sysusers s ON o2.uid = s.uid
WHERE o.type = 'TR'

Here you decide to go.

    SELECT
    [so].[name] AS [trigger_name],
    USER_NAME([so].[uid]) AS [trigger_owner],
    USER_NAME([so2].[uid]) AS [table_schema],
    OBJECT_NAME([so].[parent_obj]) AS [table_name],
    OBJECTPROPERTY( [so].[id], 'ExecIsUpdateTrigger') AS [isupdate],
    OBJECTPROPERTY( [so].[id], 'ExecIsDeleteTrigger') AS [isdelete],
    OBJECTPROPERTY( [so].[id], 'ExecIsInsertTrigger') AS [isinsert],
    OBJECTPROPERTY( [so].[id], 'ExecIsAfterTrigger') AS [isafter],
    OBJECTPROPERTY( [so].[id], 'ExecIsInsteadOfTrigger') AS [isinsteadof],
    OBJECTPROPERTY([so].[id], 'ExecIsTriggerDisabled') AS [disabled] 
FROM sysobjects AS [so]
INNER JOIN sysobjects AS so2 ON so.parent_obj = so2.Id
WHERE [so].[type] = 'TR'

A few things here...

Observe that the Alias = continues to be changed with AS Alias. the prior approach to Aliasing results continues to be deprecated by 2008 and will also be removed inside a future version.

Please visit this link for complete info on deprecated features in 2008.

Also I observe that you had been trying to drag parents tables schema information, In my opinion to be able to achieve this you'd should also join the sysobjects table on itself to ensure that you are able to properly obtain the schema information for that parent table. the query above performs this. Even the sysusers table wasn't necessary for the outcomes to ensure that Join continues to be removed.

examined with SQL 2000, SQL 2005, and SQL 2008 R2