Just recently I had been helping my friend Cal at EMC to resolve an issue with the Professional Services Tools Library (PSTL) Item Combiner utility. In a previous life, his company had installed the Manufacturing series and decided not to use it. They upgraded to Dynamics GP 10.0 and decided they wanted to take advantage of PSTL’s Item Combiner to do some cleanup work on their product master.
Not so quick! The Item Combiner failed with the message:
‘[Microsoft][SQL Native Client][SQL Server]Invalid object name ‘MOP1014’
We began an extensive troubleshooting process to find the culprit of the problem with no success, that is, until the problem was narrowed down to the following question: How to find a text within a SQL Server trigger, stored procedure, or UDF module.
The following T-SQL query accomplishes just that:
It turns out that SQL Server does have this information available when the trigger, stored procedure, or UDF object is not created with encryption.
My thanks go out to SQL Server MVP Aaron Bertrand for his contribution to this post.
– Finding Columns in Tables – Click here
Until next post!
Mariano Gomez, MVP, MCP
Maximum Global Business, LLC