Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Find a string by searching all stored procs in SQL Server Management Studio 2008

Tags:

sql-server

ssms

Is there a way to search for a string within all stored procs in SQL Server Management Studio?

like image 903
dev.e.loper Avatar asked Mar 23 '11 14:03

dev.e.loper

People also ask

How do I search for a string in SSMS?

In SQL Server Management Studio, you can output your query results to text (CTRL + T), re-run your query, click in the results pane, and CTRL + F to find strings from an unfiltered query.

1 Answers

SELECT * FROM sys.sql_modules WHERE definition LIKE '%yourstring%'
like image 144
Lamak Avatar answered Sep 29 '22 21:09

Lamak
Sign in to Comment

Related questions

How do I connect to SQL Server via sqlalchemy using Windows Authentication?
SQL Server, How to set auto increment after creating a table without data loss?
How to alter column nvarchar length without drop
Executing a stored procedure inside BEGIN/END TRANSACTION
ADO.NET Entity Framework and identity columns
Can a database table be without a primary key?
How to debug stored procedures with print statements?
Compare a date string to datetime in SQL Server?
SQL Server giving arithmetic overflow when calculating avg
How to insert a blob into a database using sql server management studio
Data length in ntext column?
what is numeric(18, 0) in sql server 2008 r2
EXEC sp_executesql with multiple parameters
SQL Server: Index columns used in like?
SQL recursive query that gets all ancestors of an item
What is the most portable way to check whether a trigger exists in SQL Server?
select data up to a space?
SQL: How do I use parameter for TOP like in SELECT TOP @amount? [duplicate]
What are the differences between T-SQL, SQL Server and SQL [duplicate]
SQL Server User Mapping Error 15023

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!