Monday, May 26, 2014

How to get all procedure script in sql server?

select ROUTINE_NAME,ROUTINE_DEFINITION from INFORMATION_SCHEMA.ROUTINES where ROUTINE_TYPE='PROCEDURE' and  ROUTINE_NAME like 'procSCH%'

But after len>4000 is not authenticated

No comments:

Post a Comment