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.
| Author |
Topic |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2010-08-06 : 10:25:19
|
| Hi All,i've a table in our dev environment, developers are not sure how the table is populating. not sure of who did that code, and how it is doing.we are using sql server 2005 ent edition.please let me know the possible ways.ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-08-06 : 11:39:54
|
| first of all check if the table is populating? and track a normal count every day to check this issue.if you find out that table is still populating, check:- any triggers on that table- any triggers on any other related table- any jobs- any ETL process that is populating this table- any procedureIf you don't find anything above, try:- changing the permissions on this table - set the tracking on the table- use SQL profiler and/or monitoring- change DataBaseOwneror simply just rename the table and wait :) for any complaints :) or any errors in any of the applications :D |
 |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2010-08-06 : 16:05:35
|
| If you want to find out where that table is being used on the server, download Redgates SQL Search utility and search for that table. If there is code on the server in that database, it will find it and show you the code. If needed, you can even search all databases. |
|
|
|
|
|
|
how a table is populating