Find the Table - DML (SELECT, INSERT, UPDATE, DELETE) Questions

Member of the LearnItFirst.com Video Training Network	\| LearnSqlServer.com \| SQL SSIS Training \| SQL Programming Tutorials \|

Welcome Guest

Search | New Posts | Members | Log In | Register

LearnSqlServer.com's SQL Server Forums » Transact-SQL Programming » DML (SELECT, INSERT, UPDATE, DELETE) Questions » Find the Table

Find the Table

Options

Previous Topic · Next Topic

senthil

Posted: Thursday, May 10, 2007 11:20:59 PM

Rank: Newbie

Joined: 5/10/2007
Posts: 1
Points: 3
Location: banglore

hi
How to find the Tables affected by one particular Day?
Any one can Help me to solve this problem

Scott Whigham

Posted: Thursday, May 17, 2007 9:25:27 AM

Rank: Super Mod

Joined: 3/20/2006
Posts: 345
Points: 748
Location: Dallas, TX

Does "affected" mean that you want to know which tables had an insert, update or delete against them? Or do you mean to find all tables that were modified (i.e., a new column was added, a data type was changed, etc) for a particular day?

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.