SQL Server Mag
SQL Server Magazine
The Smart Guide to Building World-Class Applications
Why Join
|
My Account
|
Register
|
Sign in
Search
Browse By:
Author
|
Issue
home
search
Topics
Business Intelligence
Database Administration
Kevin Kline: Thoughts from a SQL Server Old Timer
Database Development
T-SQL & PowerShell Scripting
news
blogs
Beginning SQL Server: One Step at a Time
business intelligence
database administration
database development
L.E.A.P Think
Practical SQL Server
Puzzled by T-SQL
SQL Select
SQL Server BI
SQL Server Questions Answered
Tool Time
Troubleshooting SQL Server Storage Problems
T-SQL and PowerShell Scripting
Forums
products & reviews
awards central
buyer's guide
reviews
newsletters
Events
Conferences & Workshops
eLearning Seminars
Roadshows
Virtual Events
Web Seminars
resources
ebooks
essential guides
podcasts
tip guides
trials & downloads
web seminars
white papers
more
HP Microsoft
Converged Applications
Converged Applications Blog
Microsoft UK
subscribe
SQL Server Pro Forums
View Windows IT Pro Forums
Forums
Search
Unanswered
Active Topics
Forums
>
SQL Server 2005
>
SQL Server 2005 Administration
Find specific Data in the database
Last Post 25 Jan 2012 07:25 PM by Vishal Gajjar. 2 Replies.
Sort:
Oldest First
Most Recent First
Check this box to subscribe to this topic.
Prev
Next
You are not authorized to post a reply.
Author
Messages
sql-tips
New Member
25 Jan 2012 12: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
25 Jan 2012 01: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
25 Jan 2012 07:25 PM
Try the script available here:
http://blogs.thesitedoctor.co.uk/ti...dated.aspx
You are not authorized to post a reply.
General
--Microsoft SQL Server Q&A
--SQL Server General Discussion
--Upgrading SQL Server
--Performance Tuning and Optimization
--Tool Time Forum w/ Kevin Kline
--SQL Server Database Design and Development
--SQL Azure
--Career Development and Job Opportunities
--Feedback
--Off-Topic
--3rd Party Product
--Scripts and Tools
--eNews Generator
SQL Server 2008
--SQL Server 2008 General Discussion
--SQL Server 2008 Administration
--SQL Server 2008 Analysis Services
--SQL Server 2008 Integration Services and Data Access
--SQL Server 2008 Development
--SQL Server 2008 Security
--SQL Server 2008 T-SQL
--SQL Server 2008 Reporting Services
SQL Server 2005
--SQL Server 2005 General Discussion
--SQL Server 2005 Administration
--SQL Server 2005 Analysis Services
--SQL Server 2005 Integration Services and Data Access
--SQL Server 2005 Development
--SQL Server 2005 Security
--SQL Server 2005 T-SQL
--SQL Server 2005 CLR
--SQL Server 2005 Reporting Services
SQL Server 2000/7.0
--SQL Server 2000/7.0 General Discussion
--Administration
--Security
--Tools
--Data Access
--OLAP/Data Warehousing
--Data Transformation Services (DTS)
--T-SQL
--Reporting Services
--Replication
SQL Server 6.x
--SQL Server 6.x General Discussion
Regional Forums
--US - Atlantic
--US - Northeast
--US - South
--US - Southwest
--US - Midwest
--US - Rocky Mountain
--US - Pacific
--South America
--Central America
--Africa
--Mideast
--India
--Western Europe
--Eastern Europe
--UK - Ireland
--Scandinavia
--Asia
--South Pacific
Administrators
Forums
>
SQL Server 2005
>
SQL Server 2005 Administration
Acceptable Use Policy