Link to home
Start Free TrialLog in
Avatar of anushahanna
anushahannaFlag for United States of America

asked on

getting proc from sql_modules vs routines

is there any benefit to getting the proc from one view rather than the other, to migrate it over. Both give it in single line without any formatting.

i am not going with scripting, as it will be a manual process of selecting 90+ procs, and i have it all in string format, which i can pass and get it quickly to run it in the destination.

thanks
Avatar of Mlanda T
Mlanda T
Flag of South Africa image

what???
Avatar of anushahanna

ASKER

i can copy paste from the proc and run from either of the above system views. I am asking if there are procs/cons of choosing one route over the other.

ASKER CERTIFIED SOLUTION
Avatar of BrandonGalderisi
BrandonGalderisi
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
OK. I will follow that advice. Thanks Brandon.