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
 Old Forums
 CLOSED - General SQL Server
 Getting name of all updated tables in database

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-11-16 : 09:45:42
Mukesh writes "I just need a way to get the names of all updated/changed tables in datbase in last few minutes/hours."

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-11-16 : 09:52:41
Search for Audit Trail here, there are lots of examples.

Harsh Athalye
India.
"Nothing is Impossible"
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2006-11-16 : 10:01:53
quote:
Originally posted by AskSQLTeam

Mukesh writes "I just need a way to get the names of all updated/changed tables in datbase in last few minutes/hours."



Data changes or Structure changes?


Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page
   

- Advertisement -