I know that the question I am going to ask here is not completely related to Dynamics GP but it is more toward SQL side. But still I am placing the question with the hope of getting help here.
I am trying to prepare SQL query to locate a particular string in my entire database tables.
For Example I want to find my Customer Number (‘NEGO0321’) string into my company database tables. So I want a list of tables where the mention string is present in any column.
*This post is locked for comments
Hi Bob,
I would like to apologize that I did not find such post on the forum.
But the SQL Store Procedure details given by you work like champ. It gives me big smile on my face :)
Seen several posts which have same solution.
Anyway, there is no single SQL query for it but there is a SP which gives you desired output.
SP name is spSearchOnAllDB.sql can be downloaded from below link:
blogs.msdn.microsoft.com/.../spsearchonalldb-sql-stored-procedure-to-search-an-entire-database
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (