Hi Michel,

This is the information I got from one of our SQL Server experts:

In a particular database you can run sp_tables which will produce a list of tables and the owner (which I assume is what is meant by who created them). To find the creation date you have to query the sysobjects table. It has a column crdate. So a select name,crdate from sysobjects where type = 'U' will list all user defined tables (as opposed to system tables) in a particular database. If you need anything further let me know. (JosephL@flashcreative.com)


>Is there a possibility to have a trigger at the database level on SQL Server 6.5? We would like to have a trigger to store a value whenever we add a new table to the database. Or, is there another mecanism to know that we have added a new table. Like to scan the systable.