NetserMA
asked on
Query to find a specific date in all tables
I have a database that has over 400 tables and someone has entered in 2/2910 and there is not such date. Therefore our reporting is off. Can someone give me an example of how to query all fields in all tables of a DB in SQL looking for 2/29/10?
Thanks!
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Check this URL: http://www.sqlservercentral.com/scripts/T-SQL/69207/
This one is also helpful. http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/the-ten-most-asked-sql-server-questions--1#2
exec searchalltables 'text'
Open in new window