Very simply... where do the following live after they are created?
1) DTS Scripts - Where does SQL Server save the DTS Scripts after creating using the SQL server front-end UI ?
2) Stored Procedures - What about these? Is there a specific directory I should know about?
3) Other types of Scripts
Is it in any of these dirs here? C:\Program Files\Microsoft SQL Server\80\Tools\Scripts or C:\Program Files\Microsoft SQL Server\80\Tools\Templates