Programmatically retrieve SQL Server stored procedure source that is identical to the source returned by the SQL Server Management Studio gui?
EXEC sp_helptext ‘your procedure name’; This avoids the problem with INFORMATION_SCHEMA approach wherein the stored procedure gets cut off if it is too long. Update: David writes that this isn’t identical to his sproc…perhaps because it returns the lines as ‘records’ to preserve formatting? If you want to see the results in a more ‘natural’ … Read more