With the help of below sql script we can find the given text
in SP.
SELECT
OBJECT_NAME(object_id) as [SP Name],
OBJECT_DEFINITION(object_id) as [desc]
FROM sys.procedures
WHERE OBJECT_DEFINITION(object_id) LIKE '%ProductAssemblyID%'
|
See the output
In both SP have this Text.
No comments:
Post a Comment
If you have any doubt, please let me know.