List out code of all stored procedure in SQL Server database

Posted by Raja under Sql Server category on 12/24/2008 | Views : 5321

Post Code |

Search Codes |

Code Home

You can execute following sql statement to get code of all user stored procedures.

SELECT mod.definition FROM sys.sql_modules mod INNER JOIN sys.objects obj ON mod.object_id = obj.object_id WHERE obj.type = 'p'

Alert Moderator

Bookmark It

Comments or Responses

Posted by: Deeraj on: 1/6/2009 Level:Starter | Status: [Member]

In SQL Server 2005, much more simplified solution is available by the way of using Dynamic Management Views

Select top 1 routine_definition,* from information_schema.routines

Latest Code Snipptes

Azure Function - Connect to MS Dynamics using application user - .NET core 3.1
MS Dynamics 365- Custom action - Read input parameter values from plugin
MS Dynamics 365- Disassociate record from N-N relationship entity
Search box with icon in Navbar in bootstrap 4
Remove HTML tags using Regular Expression in C#
MS Dynamics 365- Close Quote from C# / Custom action
How to show and hide submenu in tabs using jquery
How to add star rating and submit rating
MS Dynamics 365 - Create an email activity using dynamics crm Rest API - C#
More ...