Ability to export the sql behind a SP / view / query to an ascii file ?
Posted on 2004-03-23
Is there a way that I can export the SQL behind a stored procedure or view, into a text file, or preferably into a recordset string field.
My absolute ideal would to have a stored procedure that returns a recordset with the database object name and the SQL in the object, be it a stored procedure or a view, that I can use to get ascii copies of all my db objects, such that I can see their progress over time in CVS.
Any ideas ?