Hi Rene,

MSSQL SERVER DTS defaults are stored procedures and user logins are not included, before proceeding, check the option include stored procedures, also other objects needed in your new database.

>>Hello all,
>>
>>I copy a database by using the Data Transformation Services, but did not copy the stored procedures.
>>
>>Does any body knows how to copy stored procedures betweem databases.
>>
>>Thanks,
>>Sergio
>
>
>Sergio,
>
>You can do it in the DTS by choosing "Copy objects and Data between SQL Server databases" option.