Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-02-20 : 07:34:54
|
| Michael writes "I have 2 servers nemed SQL1 (Production Machine) and SQL2 (Reporting Database) On SQL1 there is a database called Prod01. At night a DTS package is scheduled which does a database copy of the above database from SQL1 to SQL2. The package is set to drop destination objects first. Everything was working fine but now the package fails at it cannot create a duplicate foriegn key. What would the cause of the problem be ?" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-02-20 : 08:00:28
|
| Have you thought about using sql-dmo instead - should be simpler.Seewww.nigelrivett.comDMO transfer==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
DTS Database Copy