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 |
|
Hommer
Aged Yak Warrior
808 Posts |
 Posted - 2004-08-18 : 16:45:57
|
| I tried to copy sp and views between sql2k servers. Under the copy sql server object task property, I selected each objects I want. The DTS runs to completion without error. But here is no single object in the destination.What's going on? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-18 : 16:50:17
|
| Why not copy them using the Generate SQL Script wizard? Or will this be scheduled?Tara |
 |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2004-08-18 : 17:08:04
|
| I will try. Never used it before for moving several dozens views/SPs. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-18 : 17:11:15
|
| It works great. You can select all views and stored procedures instead of doing them one by one. It allows you to specify drop and create if you'd like which is the default.Tara |
|
|
|
|
|
|
DTS succeeded, but no obj copied