information_schema.tables, triggers, cursors

[bhavna]

how do i return only the tables created by the user?
in three of my databases i am inserting one record per 5 secs. in all the tables. how good is using triggers for 'insert instead of' for these tables?

[MAK]

Nothing wrong in using triggers on such tables. It depends on your architecture and what you are trying to accomplish.

one row per 5 sec is not a huge volume.

[MAK]

This will show all user owned objects
---------------------------------------
select o.name as Objectname ,s.name as Owner from sysobjects o,sysusers s
where o.uid=s.uid order by o.name,s.name

[MAK]

--This will show all user owned objects
for one particular user


select o.name as Objectname ,s.name as Owner from sysobjects o,sysusers s
where o.uid=s.uid and s.name = 'username' order by o.name,s.name

[Osiris]

Mak, Is it possible to tailor this script to return

a) only tables
b) only user tables

Cheers

Os

[Osiris]

Sorry - just worked out the User type objects - just added in

and xtype = 'U'

into the WHERE clause