Sql Query to Get the Text of all the stored procedure and Views
Sql Query to Get the Text of all the stored procedure and Views with out using sp_helptext
Query to get the Text of all the Stored Procedures
SELECT Text AS StoredProcedureTexts
FROM SysComments
WHERE ID
IN
(
SELECT Id
FROM SysObjects
WHERE XType = 'P'
}
Query to get the Text of all the Views
SELECT Text AS ViewTexts
FROM SysComments
WHERE ID
IN
(
SELECT Id
FROM SysObjects
WHERE XType = 'V'
}
-----------1111111111-------------------
hey
this one is awesome code snippet
keep it up
put good codes and earn money and points
------------!!!!!!!!!!-------------------