Identify Text in Stored Procedures to include Table Name

Question

Identify Text in Stored Procedures to include Table Name

Welsh Corgi

SSC Guru

Points: 116520
More actions
January 23, 2017 at 7:52 am

#334280

I need to Identify Text in Stored Procedures to include Table Name.
The following only identifies the SP Name. What view and how do I join to get the table name.
SELECT name
FROM sys.procedures
WHERE Object_definition(object_id) LIKE '%LastIDNumber%'
ORDER BY Name
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323547 More actions · Answer 1

duplicate post.
no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.
the "Latest Posts" link shows us everything.
continue the thread here:
https://www.sqlservercentral.com/Forums/1852098/Identify-objects-that-do-not-use-an-Identity-Column-but-a-Lookup-Table-to-generate-an-Unique-Identif

specifically you've ignored all the previosu advice to use sys references data. go back to the original thread, and show what you've tried so far

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 2

Lowell - Monday, January 23, 2017 8:21 AM
duplicate post.
no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.
the "Latest Posts" link shows us everything.
continue the thread here:
https://www.sqlservercentral.com/Forums/1852098/Identify-objects-that-do-not-use-an-Identity-Column-but-a-Lookup-Table-to-generate-an-Unique-Identif
specifically you've ignored all the previosu advice to use sys references data. go back to the original thread, and show what you've tried so far

Sorry but I did not think it was a duplicate post because what I'm attempting to do is different then the other post.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/