The list of stored procedures are filtered based on your filter criteria.In the filter settings window against the property Name, you can choose one of the Operator from the list (Equals, Contains, Does not contain) and enter the search phrase (or stored procedure’s name or partial name) under Value and then click OK.From the right-click menu, select Filter in the right-click menu.Right Click the Stored Procedures folder.In the Object Explorer in SQL Server Management Studio, go to the database and expand it.Below are the steps for using filter settings to find stored procedure. #DB TEXT PROCEDURE FULL#OBJECTPROPERTY(object_id, 'IsProcedure') = 1 ANDįind Using Filter Settings In Object ExplorerĪnother simple way to find the stored procedure by its full or partial name is by using the filter settings option in SQL Server Management Studio Object Explorer. This system view can be used to fetch the user defined programmability object’s definition / source code. Sys.sql_modules is a system object catalog view. This system view can be used to fetch the object id and the definition / source code of stored procedures, views, trigger, rule and other programmable objects within the database. Sys.syscomments is a system compatibility view. Later on in this article you will see about using INFORMATION_SCHEMA.ROUTINES to search stored procedure containing text. For now I’ll give you the query to find the stored procedure by its name. You can use this view to search for stored procedure by its full or partial name and the stored procedures containing text. This system view can be used to fetch all the details about the stored procedure like, name, definition / source code, database schema, created and modified date, etc. INFORMATION_SCHEMA.ROUTINES is a system information schema view. Sys.procedures system table has the name of the procedure, object id and other details like created date, modified date, etc… So, if you know part of the stored procedure’s name, then you can use this option to find the list of stored procedures having the phrase in the name.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |