Find specific Data in the database

Last Post 25 Jan 2012 08:25 PM by Vishal Gajjar. 2 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
sql-tips
New Member
New Member

--
25 Jan 2012 01:32 PM
I have some strange number (877737787999) in the application logs and I suspect it is coming from the database but not sure which table this value stores. Is there anyway search the entire database which table this data belongs to? just like we have sysobjects and syscolumns to find the structure objects?
gunneyk
New Member
New Member

--
25 Jan 2012 02:44 PM
There is no easy way to do something like that. If it is an application log then I would look at the application code to see where it may be getting this from. It would be a lot easier than fishing thru every table and column inthe database.
Vishal Gajjar
New Member
New Member

--
25 Jan 2012 08:25 PM
Try the script available here: http://blogs.thesitedoctor.co.uk/ti...dated.aspx


Acceptable Use Policy
---