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.

Avatar of Mlanda T
Mlanda T
Flag of South Africa image

Avatar of anushahanna


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.

Avatar of BrandonGalderisi
Flag of United States of America image

Link to home
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.