I'm working on an interface to manage a bunch of my websites. Basically, it's a copy of Enterprise Manager written using web-services. So, I can set up the module on any one of my systems and execute SQL calls via ajax calls.
Right now, I choose a system, and I see a list of all the views, functions, and procedures in the DB. I'd really like it if I could write a script where I can right-click on a stored procedure and have the "Script stored procedure as Alter..." as an option.
Where is that information??