selectstarfromyogi

sql server DBA ,sql server 2008 , 2012 , 2014 ,sql

Menu
Search
Skip to content
  • Home
  • About

find stored procedure

Find Stored procedure in SQL Server

we can find the Stored procedure using TSQL or by GUI using filter

TSQL:

select * 
from 
   sys.procedures 
where 
   name like '%SP_name%'

GUI :

January 27, 2021yogigollapudi find stored procedure Leave a comment

Categories

  • DEVOps (1)
  • Errors (9)
  • FUN (1)
  • Performance Tuning (11)
  • powershell (12)
  • T-SQL (43)
  • Uncategorized (154)

Blog Stats

  • 39,569 hits
Follow selectstarfromyogi on WordPress.com
Create a free website or blog at WordPress.com.
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Subscribe Subscribed
    • selectstarfromyogi
    • Already have a WordPress.com account? Log in now.
    • selectstarfromyogi
    • Subscribe Subscribed
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...
 

    Design a site like this with WordPress.com
    Get started