Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.
best system table to search code
what is the best system table in 2000 and 2005+ to search for specific text in a code (UDF or proc) etc
thanks
thanks
Asked:
Who is Participating?
Always and all versions I use:
usemydb
go
select * from sys.syscomments where text like '%something%'
go
this will return ALL unencrypted SQL code objects containing "something"
usemydb
go
select * from sys.syscomments where text like '%something%'
go
this will return ALL unencrypted SQL code objects containing "something"
"Returns the first 4000 characters of the definition text of the function or stored procedure if the function or stored procedure is not encrypted. Otherwise, returns NULL."
http://msdn.microsoft.com/en-us/library/ms188757%28SQL.90%29.aspx
Where do you get the Views and Triggers code from?
As far as I'm aware they are ALL in sys.syscomments.text column
http://msdn.microsoft.com/en-us/library/ms188757%28SQL.90%29.aspx
Where do you get the Views and Triggers code from?
As far as I'm aware they are ALL in sys.syscomments.text column
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
All Courses
From novice to tech pro — start learning today.
SELECT ROUTINE_NAME
FROM INFORMATION_SCHEMA.ROUTINE