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 |
boreddy
Posting Yak Master
172 Posts |
Posted - 2010-07-26 : 04:59:28
|
I have one database it contain many tables, view, procedures, triggersAnd running many jobs on that database I need to know in which way the data is loading in to table (in the sense by using the procedure or trigger or job) and I want to know the object nameIf it is possible please tell me urgent |
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-07-26 : 06:21:18
|
Firstly, i suggest you to take a look the application that is running front end. Once you undestand how the application is working than you will know how data are comming into sequel server.Secondly, check for any replication processes if there are running among servers.Thirdly, yes jobs and triggers are also the way to insert data into tables. this consists either of views, queries, procedures, etc.It will be also helpful to know your database schema. |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-07-26 : 09:14:21
|
Alter the table to include a column like belowalter table table_nameadd application_name varchar(100) default app_name()Now everytime data are added, that column will have a source name of where it comes fromMadhivananFailing to plan is Planning to fail |
|
|
|
|
|