Hello-

I am attempting to transfer stored procedures from a dev database to a
production database. Using the DTS Import/Export Wizard, I select "Copy
objects and data between SQL Server databases."

On the select objects to copy dialog, I deselect copy data and copy all
objects. Using the Select objects command button, I select all and check all
stored procedures.

Running the wizard, the stored procedures are copied, but all of my
destination tables are also truncated. There were no tables selected in the
Select Objects dialog.

I do not want to append data to the destination, and I do not want to
replace the destination data.

Please help me understand why this is happening.

I know that I can run a T-SQL script to create the stored procedures, and
that is what I will do, but I want to understand why when "Copy data" is
deselected, and no tables are selected to be copied to the destination, why
the destination tables are truncated.

Thanks.

Shawn

Uncheck include all dependent objets

http://sqlservercode.blogspot.com/


"poul0004" wrote:

That was it.

Thank you.

"SQL" wrote: