<div>
You can also write queries against the information.schema_views (located in the master database) to retrieve information....<br />
<br />
Brett
</div>


You can also write queries against the information.schema_views (located in the master database) to retrieve information....

Brett

<div>
sp_helptext &nbsp;seems to do the job :)<br />
<br />
is there a master SP to return all the stored procedures and views, such that I can then write my own SP to get the list and then call sp_helptext on that list ?<br />
<br />
Regards<br />
Marts<br />
<br />

</div>


sp_helptext  seems to do the job :)

is there a master SP to return all the stored procedures and views, such that I can then write my own SP to get the list and then call sp_helptext on that list ?

Regards
Marts



<div>
Actually I think the information_schema views only return the first 4K of object text, so it's not a safe way to get the source. &nbsp;You really need to use sp_helptext.
</div>


Actually I think the information_schema views only return the first 4K of object text, so it's not a safe way to get the source.  You really need to use sp_helptext.

<div>
<div class="content wysiwyg-content">
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.<br />
<br />
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.<br />
<br />
Any ideas ?<br />
<br />
Regards<br />
Marts<br />

</div>
</div>


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 ?

Regards
Marts


Ability to export the sql behind a SP / view / query to an ascii file ?

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.