stored procedure

From: Anirban (tulu_paul_at_hotmail.com)
Date: 11/23/03 

Date: Sun, 23 Nov 2003 11:59:41 +0530

I have few questions

1. How can we write to a text file using stored procedure.(what is the
code)
2. I wrote some stored procedure, and I donot want any other person to view
it. How to achive this?
3. Where does the stored procedure get stored (which direectory)?

Thanks,
Paul