spacing when I script my objects

[mjp483]

After I script my procs from enterprise manager, I paste the script into query analyzer and run it. When I open the newly scripted procs, they are all missing the spacing I that was present in the source procs. Is there a way to maintain the spacing?

 

[amrita418]

mjp483,
I am not sure if I understand your question right, but here is my take on it.

If you create a procedure in query analyzer (with the text indended) then to retain the code double click on stored procedure in EM (under databases --> stored procedures) to view the code (with indentations intact). On the other hand if you run sp_helptext 'your_procedure_name' in QA then the output is not indented.


Hope this helps,
Regards,
--aa