Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Find Data Source Expand / Collapse
Author
Message
Posted Wednesday, July 17, 2013 5:37 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, August 5, 2014 10:09 AM
Points: 227, Visits: 713
Hi Team,

am having a table called 'all_data' with columns id, data_src.

in above table records are not entering directly, records are inserted into above table based on some triggers and stored procedures.

am new to this environment, how to find where and when the records are entering to particular table.

Please sugggest.
Post #1474507
Posted Wednesday, July 17, 2013 5:54 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, August 6, 2014 7:12 AM
Points: 2,255, Visits: 2,717
There is not enough information to answer your question.
You say there are stored procedures and triggers involved. So you have allready a clue to how the data is entered. Take a look at the code in the stored procedures and triggers to see what is going on.
You can query the table [sys].[sql_expression_dependencies] to see what objects reference the table in question. The information in this table can be out-dated due to renaming objects.


** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Post #1474518
Posted Wednesday, July 17, 2013 5:58 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 12:53 PM
Points: 12,903, Visits: 31,966
an example of checkign the references HanShi mentioned:

--Objects:
SELECT objz.name,
fn.*
FROM sys.objects objz
CROSS APPLY sys.dm_sql_referenced_entities(schema_name(schema_id) + '.' + objz.name,'OBJECT')fn
WHERE referenced_entity_name ='all_data'

and just in case, you can check the definitions of all objects as well:
select OBJECT_NAME(object_id) As ReferencingObject, *
from sys.sql_modules
where definition like '%all_data%'





Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1474519
Posted Wednesday, July 17, 2013 6:42 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, August 5, 2014 10:09 AM
Points: 227, Visits: 713
Thank you Hanshi and Lowell,

Your Suggestions help me a lot.

Thank u once again.
Post #1474558
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse