How to identify new objects as been create in Data

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)

How to identify new objects as been create in Data

Author

Topic

ramemail.n
Starting Member

8 Posts

Posted - 2010-06-24 : 03:54:29

Hiall,

i want to Know if any new tables or Sp's or Functions created in
the sql server database to monitor every day is there any Script to identfy everday new objects creation.

thanks,
Ramm
DBA SQL

Rammohan N

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2010-06-24 : 04:03:37


select *
from   sys.objects
where  create_date >= '2010-06-24'

KH
[spoiler]Time is always against us[/spoiler]

ramemail.n
Starting Member

8 Posts

Posted - 2010-06-24 : 04:07:05

thanks for this ,

i want know all SP's and functions,views and tables

Rammohan N

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2010-06-24 : 04:19:21

sys.objects contains all objects in the database. You can filter those you are interested using the type column. Refer to BOL for further information

http://msdn.microsoft.com/en-us/library/ms190324.aspx

KH
[spoiler]Time is always against us[/spoiler]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources