getting proc from sql_modules vs routines
Posted on 2010-09-13
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.