Activity overview
Latest activity by sgia
I found that I can do a "Generate SQL scripts" from Enterprise manager (select all the SPs, right click, All Tasks, Generate SQL Script) -
let it create the DROP and CREATE scripts for ALL the SPs, then copy the resulting script to Query Analyzer and run LayOut SQL over that.
Worked like a charm.
SG / comments
I found that I can do a "Generate SQL scripts" from Enterprise manager (select all the SPs, right click, All Tasks, Generate SQL Script) -
let it create the DROP and CREATE scripts for ALL the SPs,...
David Atkinson wrote:
Thanks for the request. I take it you're both looking for something slightly different? Sgia, you want to modify the layout of all your database's stored procedures and Fatherjack you'd like to modify a set of SQL scripts in a specified folder?
David Atkinson
Product Manager
Red Gate Software
Yes, I would like to have the CTRL-SHIFT-Y functionality applied to all stored procedures in a database. / comments
David Atkinson wrote:
Thanks for the request. I take it you're both looking for something slightly different? Sgia, you want to modify the layout of all your database's stored procedures and Fath...
Batch run for Layout?
Hello, can anyone tell me if it is possible to BATCH run the SQL layout command? I have a bunch (several hundred) stored procedures I would like to clean up and a batch function would be great.
Th...