How to find the tables that gets affected

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 2008 Forums

Transact-SQL (2008)

How to find the tables that gets affected

Author

Topic

raghu_grdr
Starting Member

17 Posts

Posted - 2011-07-26 : 01:01:02

Hi,

Is there a way to find the tables that gets affected in SQL Server 2008 when we run a project from Asp.net.

Regrads,
Raghu.G

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-07-26 : 01:41:13

You can run a trace to capture what it's doing. A trace can easily be configured via SQL Profiler, although it's best to do a server-side trace for performance reasons.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources