where is this table populated then? must be loaded some how.

Question

where is this table populated then? must be loaded some how.

mcfarlandparkway

SSCertifiable

Points: 7699
More actions
July 11, 2016 at 10:36 am

#319888

I have a report (.rdl file) - and a table called person and this table is using only in one stored procedure and that procedure is using in rdl file.
I don't see this table is using anywhere in batch files or in SSIS packages.
Are there any options to check it? other than these?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Sean Lange SSC Guru Points: 286590 More actions · Answer 1

mcfarlandparkway (7/11/2016)
I have a report (.rdl file) - and a table called person and this table is using only in one stored procedure and that procedure is using in rdl file.
I don't see this table is using anywhere in batch files or in SSIS packages.
Are there any options to check it? other than these?

Maybe there is a stored proc that inserts data into that table? Maybe you have pass through sql from some other application somewhere? You might check out sql search from red gate. It is free and worth every penny!!! http://www.red-gate.com/products/sql-development/sql-search/[/url]

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

GSquared SSC Guru Points: 260824 More actions · Answer 2

You can trace events in a database, even at the table level. Use either a trace, or (better) extended events. (Search for "sql extended events" to find out how to set those up.)

If anything is updating the table, you can find out that way.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

mcfarlandparkway SSCertifiable Points: 7699 More actions · Answer 3

Where I have to search for sql extended events or trace in management studio?

I never used it before.

GSquared SSC Guru Points: 260824 More actions · Answer 4

mcfarlandparkway (7/11/2016)
Where I have to search for sql extended events or trace in management studio?
I never used it before.

I use Bing, because I'm strange, but most people use Google.