>Hi.
>
>Is there any small app available out there that reads a given DB inside SQL Server and extracts things like SPs, UDFs, Triggers, etc, and put them into individual text files somewhere?
>
>Yeah, I know that that's not a hard thing to write, but I wonder whether someone haven't came up with such a thing yet. :)
>
>TIA
Claudio,
Have you looked at possibly using SQLDMO? Anything that you can do in the Enterprise Manager, you can automate with SQLDMO.
If your interested, Andrew Coates did a session on it at Whilfest. His presentation is included in the downloads.
George
Ubi caritas et amor, deus ibi est