Getting the "Alter Procedure..." or "Alter View..." scripts from SQL Service via SQL?
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??
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??
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER