Everything you need to know about backup and disaster recovery with AWS, for FREE!
Course Of The Month
4 days, 5 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
best system table to search code
Posted on 2011-03-08
what is the best system table in 2000 and 2005+ to search for specific text in a code (UDF or proc) etc
thanks
thanks
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3
3-
3
9 Comments
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
Featured Post
On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Suggested Courses
Course of the Month4 days, 5 hours left to enroll
691 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.