Updated: spSearchOnAllDB: SQL Stored Procedure to Search an Entire Database

David Meego - Click for blog homepageFrom the Useful SQL Scripts Series.

Back in December 2008, I posted an article providing the spSearchOnAllDB stored procedure, originally created by Oufimtsev Gleb.

Based on feedback in the comments of that article, I have made two lots of updates to the script to fix some issues:

  1. It now handles tables and columns with long names which can include spaces.
     
  2. It now automatically doubles up any single quote characters in the search string passed to the stored procedure to avoid early termination of the strings used for the dynamically created code.

 

Note: To pass a single quote (‘) into the stored procedure, you will need to double it up to 2 single quotes (”) when you type in the parameter.

For example: to search for any single quotes in the data use: exec spSearchOnAllDB ‘%”%’

 

The updated script is provided at the bottom of the original post:

 

Enjoy 

David

View original post here:
Updated: spSearchOnAllDB: SQL Stored Procedure to Search an Entire Database

July 31, 2013 · David Musgrave · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 444

Create and update report groups in Microsoft Dynamics …

2013 2:59 PM. Comments 0. This video describes the options available for report group distribution in Management Reporter. http://blogs.msdn.com/b/dynamicscpm. $core_v2_language.FormatString($core_v2_language.

Read More:
Create and update report groups in Microsoft Dynamics …

July 30, 2013 · Community Editor · No Comments
Tags: , , , ,  · Posted in: Blogs I Follow Total Views: 257

View and interact with report groups in Microsoft Dynamics …

Comments 0. This video describes how to view and interact with a report group in the Management Reporter web viewer. http://blogs.msdn.com/b/dynamicscpm. $core_v2_language.FormatString($core_v2_language.

Visit site:
View and interact with report groups in Microsoft Dynamics …

July 30, 2013 · Community Editor · No Comments
Tags: , , , ,  · Posted in: Blogs I Follow Total Views: 240

Microsoft Dynamics Management Reporter Report Groups Updates …

Search Everything; Search Microsoft Dynamics GP Comments 0. This video introduces the updates made to Report Groups in Management Reporter 2012 CU6. http://blogs.msdn.com/b/dynamicscpm. $core_v2_language.

Continue Reading:
Microsoft Dynamics Management Reporter Report Groups Updates …

July 30, 2013 · Community Editor · No Comments
Tags: , , , ,  · Posted in: Blogs I Follow Total Views: 262

Quick Tip: Debugging Visual Studio Tools – Developing For Dynamics GP

Awesome tip up there on Developing For Dynamics GP blog on how to debug VS Tools For Dynamics GP.

I am late in blogging about this post. But NOW is the time, as this post just saved my 1/2 day. Seriously. Not kidding. I was stuck with one SQL query execution. There were records to be retrieved, but my code didn’t. After 5-10mins of frustrated troubleshooting, I remembered this post. I should have done that immediately then, but I didn’t.

I setup my VS Tools project to launch GP as instructed on this post and within 2 minutes I could find the issue.

This one deserves to be there on Microsoft Dynamics GP Cookbook (technical).

VAIDY

Filed under: Customizations, Debugging, GP Administration, SQL, SQL Profiler, Support, Tools, Troubleshooting, Visual Studio Tools, VS Tools

More here:
Quick Tip: Debugging Visual Studio Tools – Developing For Dynamics GP

July 30, 2013 · Vaidyanathan Mohan · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 402

On-demand webinar: Accounts Receivable Month-end Procedures …

Search Dynamics GP Blog. Subscribe. Enter your E-mail address in the box below and subscribe to our blog feed. Subscribe in a reader · ← What Are The Keys To Job Costing Success? Announcing Data Import Tools for …

View article:
On-demand webinar: Accounts Receivable Month-end Procedures …

July 30, 2013 · tidestone · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 244

Troubleshooting the Microsoft Dynamics GP 2013 Web Client – Wrap Up

Series Wrap Up



It’s been a couple of exciting weeks reviewing the position, procedures, and tools available for troubleshooting the Microsoft Dynamics GP 2013 Web Client and I hope that you walked away with an idea of where to turn and what it takes to resolve your issues.

Troubleshooting may not be glamorous or exciting and frankly a lot of folks down right don’t like it, but I personally find it to be a challenge. I like when stuff breaks – figuratively speaking – knowing that you (and a handful of others) are the only one capable of fixing it. Also, it is awesome when you can showcase your Angus MacGyver (yes, his first name was Angus!) ingenuity by using resources and tools that have been in the public domain for a while, “common knowledge” if you will, and can now be applied in the context of GP.

I want to synthetize the series by providing a link to all the articles covered, below:

Part 1: Microsoft Dynamics GP Support Team’s Posture

Part 2: Resolving Microsoft Dynamics GP 2013 Web Client Implementation Issues

Part 3: Resolving Microsoft Dynamics GP 2013 Web Client Functional Issues

Part 4: Tools for Troubleshooting Web Client issues: the Web Client Diagnostic tool

Part 5: Tools for Troubleshooting Web Client issues: Fiddler

Part 6: Tools for Troubleshooting Web Client issues: Other Tools

Part 7: Tools for Troubleshooting Web Client issues: Command Line Tools

Well, I am preparing for a new series of articles, but in the mean time stay tuned.

Until next post!

MG.-
Mariano Gomez, MVP
IntellPartners, LLC
http://www.IntellPartners.com/

Read More:
Troubleshooting the Microsoft Dynamics GP 2013 Web Client – Wrap Up

July 30, 2013 · Mariano Gomez · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 330