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 - 2002-11-26 : 08:10:38
|
| Cay writes "i used dts to upload the sql database to my web host(hostway.com). the db has 6 tables and 10 stored procs. the db on my local machine is the same. i made some changes. deleted 2 tables and 5 stored procs. i use dts to shoot the sql db back up to the sql server at hostway. it fails 100% of the time with the objects. i cant get rid of the stored procs or overwrite them. error message of "there is already an object name test_StoredProc". i pretty much cant edit or overwrite stored procs or tables in the database. sql server2000 evaluation edition on local machine. sql server2000 on webhost machine. does that matter? xp pro on local machine and not sure what OS on host. please help!!!" |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2002-11-26 : 23:03:37
|
| Do you have the ability to restore backups. If so then I would just backup up the on the local machine. Drop the database on the webhost and restore the backup from the local machine and everything should be there.There is also an option to drop existing objects first make sure you have that checked off.Edited by - ValterBorges on 11/26/2002 23:04:36 |
 |
|
|
|
|
|
DTS