date of when object created - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

date of when object created

Author

Topic

TRACEYSQL
Aged Yak Warrior

594 Posts

Posted - 2010-02-16 : 17:30:37

I am trying to get a report of all objects, tables, sp created and what date this was created.

--This provides the tables where I can sort only giving me dbo or particular schema

SELECT *
FROM information_schema.Tables
where TABLE_SCHEMA = 'DBO' OR TABLE_SCHEMA = 'SALES'

If i try to join this to get the date created.
SELECT * FROM SYS.OBJECTS
This only has the object not the schema

Any ideas.

Bustaz Kool
Master Smack Fu Yak Hacker

1834 Posts

Posted - 2010-02-16 : 19:03:28

SELECT schema_name(schema_id) schemaname, * FROM SYS.OBJECTS

=======================================
Few things are harder to put up with than the annoyance of a good example. (Mark Twain)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources