InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 02:44:09 GMT20http://www.sqlservercentral.com/Forums/Topic549824-145-1.aspxYou can use below query:sp_stored_procedures. Just try it once.Thanks,Arif.Fri, 17 May 2013 06:22:36 GMTArifresumehttp://www.sqlservercentral.com/Forums/Topic549824-145-1.aspx[quote][b]Steve Jones - Editor (8/10/2008)[/b][hr]I'd recommend select * from information_schema.routines[/quote]Oh yeah, I forgot about this one. I like it much better.Sun, 10 Aug 2008 18:56:19 GMTRBarryYounghttp://www.sqlservercentral.com/Forums/Topic549824-145-1.aspxEither of the other suggestions will work, but I would agree with Steve because INFORMATION_SCHEMA is an ANSI standard while sys.procedures is a Microsoft view that could be deprecated or changed.Sun, 10 Aug 2008 18:35:44 GMT Jack Corbetthttp://www.sqlservercentral.com/Forums/Topic549824-145-1.aspxI'd recommend select * from information_schema.routinesSun, 10 Aug 2008 17:00:46 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic549824-145-1.aspxSelect * from sys,proceduresSat, 09 Aug 2008 22:59:54 GMTRBarryYounghttp://www.sqlservercentral.com/Forums/Topic549824-145-1.aspxHi to all,I have a small doubt.If we want to know the see all the tables in a database we normally use sp_tables.I want to see all the stored procedures ina database. how we can see all the stored procedures in a database.Thanks,sandhyaSat, 09 Aug 2008 22:11:39 GMTsandhyarao49