Monitering DDL operations - 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 2000 Forums

SQL Server Administration (2000)

Monitering DDL operations

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-11-21 : 07:54:44

Phani writes "hai frineds,

i want to moniter database objects modification in my database(i.e Creation of new Object(Tables), Deletion). Whenever user adds a new object, deletion i want to capture that into
one Table for refernce.
i am using SQL2000 and Win2000.
is any help ? Thanks

Phani"

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2002-11-21 : 08:08:48

Hai

Any chance you need to do it because of something like this ? http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=21774

Damian

ValterBorges
Master Smack Fu Yak Hacker

1429 Posts

Posted - 2002-11-21 : 08:47:42

A few days ago Rob posted a link to a program that is able to look at the logs and extra such information.

http://www.sql-server-performance.com/log_explorer_spotlight.asp

http://www.lumigent.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources