SQL Server Management Studio - find stored procedure by name over multiple databases
I have recently joined a software project that has approximately 20-40 databases.
Each database has at least 200 stored procedures, some of them have many more, so it is very slow for me to search for a particular procedure manually.
I know that there is a stored procedure which I need to look at to fix a bug, somewhere in the entire project, it is called XYZ_procedure
How do I search for this procedure over all of my databases in SQL Server Management Studio?
If you need to find database objects (e.g. tables, columns, triggers) by name - have a look at the FREE Red-Gate tool called SQL Search which does this - it searches your entire database for any kind of string(s).
It's a great must-have tool for any DBA or database developer - did I already mention it's absolutely FREE to use for any kind of use??
- Convert hour to 12 hr format after extracting 'hour' using DatePart(hour,Datetime)
- SQL Management Studio can't drag table / object from Explorer to Query Editor
- How can I put a where condition on a SqLite view statement?
- Get 2 Digit Number For The Month
- Set a column unique without being the primary key
- How to simulate a deadlock in SQL Server in a single process?
- "The big SQL RegEx": How do I RegEx split a SQL query?
- Determine column to insert into based on content
- Can a 4 column address be merged into a 2 columns address with a SELECT statement?
- How to write a "recursive update"?
- hierarchical query in Oracle
- How to Select all Columns from a Table for a Record - but to exclude a Column if all entries for that Record in said Column are null?
- Find patients admitted multiple times for the same primary diagnosis in SQL
- Updating SQL Server records with replace
- Export data from dynamic XML hierarchy in SQL Server
- How to resolve this error Ora-25137 "Data Value Out of range" in oracle
- Writing a SQL Query with multiple Where statements
- VBA - Convert a few numeric cells as text
- MySql: unknown column id in 'field list'
- SQL Server TDS protocol response problem when calling a stored procedure
- Can Postgres use the foreign key (between two tables) as the "ON" clause when LEFT JOINing them?
- Count matching value in two columns in SQL
- Why UNION and UNION ALL don't work in my code?
- Could not drop object 'dbo.Table1' because it is referenced by a FOREIGN KEY constraint
- PostgreSQL: Give all permissions to a user on a PostgreSQL database
- How does group by works in sequelize?
- Cursor bug when editing sql file
- Add a given value from a column based on the value from another column
- How can I make SQL case sensitive string comparison on MySQL?
- How to fix "java.sql.SQLException: Can't call commit when autocommit=true"