Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Track table deletions / adds

Status
Not open for further replies.
leprikon

leprikon

IS-IT--Management
Jan 29, 2003
20
US
The error log shows who logs on, backups etc .. but doesn't show when a table is created in a database or when a table is deleted. How do I track this in SQL 2000 Server ?
 
Sort by date Sort by votes
No such system table will return you a action taken against one table.But you can trap with SQL Profiler(filtered by T-SQL Statement), but I think it's too over-headed to do so.

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

AndrewWiggins99
  • Locked
  • Question
Read Only access on a specific table 1
Replies
3
Views
125
fredericofonseca
fredericofonseca
dgillz
  • Locked
  • Question
How to create login that has access to only certain tables in a database
Replies
4
Views
149
SQLBill
SQLBill
niall5098
  • Locked
  • Question
collation in table edit
Replies
1
Views
81
gmmastros
gmmastros
TheBugSlayer
  • Locked
  • Question
Partioning a table with non-clustered index but no clustered index
Replies
0
Views
74
TheBugSlayer
TheBugSlayer
boanrb
  • Locked
  • Question
Table Creation: Referential Integrity
Replies
2
Views
75
boanrb
boanrb

Part and Inventory Search

Sponsor

Back
Top