Microsoft Dynamics GP (Archived)

String Value in SQL database

(1) Share

Report

Posted on by Khalid Shaikh

Hi,

I am trying to find specific path value in database.

How do I find string value such as "C:\temp\abc%" in a particular database of all tables.

Thanks in advance.

Shaikh

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Don Wisch 660 on at

Like (0)

Report

Check this out but be careful as this could turn into an intense search.

stackoverflow.com/.../search-all-tables-all-columns-for-a-specific-value-sql-server

Was this reply helpful? Yes No
Suggested answer

Tom Mathew 1,750 on at

Like (2)

Report

Check this beautiful procedure by David which perfectly fits you...

blogs.msdn.microsoft.com/.../updated-spsearchonalldb-sql-stored-procedure-to-search-an-entire-database

Was this reply helpful? Yes No
Don Wisch 660 on at

Like (0)

Report

Good one Tom... completely forgot about that one :)

Was this reply helpful? Yes No
David Musgrave MVP ... 14,095 Most Valuable Professional on at

Like (1)

Report

Tom, You beat me to it. :-)

Was this reply helpful? Yes No
Suggested answer

L Vail 65,271 on at

Like (1)

Report

Shaikh,

You could also use a FREE search tool from Apex called Apex Search. It is very good and will allow you to look for dates, strings, numbers, dates, etc. and you can specify which tables www.apexsql.com/Download.aspx

Check it out, I think you'll like it. It's my 'go to' tool for searching the database; you can even select to search ALL of the databases in a single search.

Kind regards,

Leslie

Was this reply helpful? Yes No
Jeyakumar 592 on at

Like (0)

Report

Hi Shaikh,

GP Company Database having Some default Stored Procedure for Searching particular String Value.Using below Procedures you can find Date,Number and String Value.

dbo.SearchAllTablesForDate

dbo.SearchAllTablesForNumber

dbo.SearchAllTablesForString

Hope this helps!!!

Was this reply helpful? Yes No