Can anyone show me how to perform a DTS.TransferObjectsTask which does
not strip white space from stored procedures? When we move the tables,
structures, indices from an init db to a dev db all white space (blank
lines) are lost. We end up having to use SQL Programmer to copy/paste
the sp's. We have looked at the switches (ScriptOption,
ScriptOptionEx) to no avail.

Thanx!

In message <734863e2.0401220719.f8b290d (AT) posting (DOT) google.com>, cbondeson
<cbondeson (AT) delphihealth (DOT) com> writes
I think SQLDMO could be used to automate the transfer instead.

Never noticed that behaviour before, it is a bit anti-social.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org