I was doing a DTS from one server to another of some stored procedures as objects to replace some existing ones.
For some reason it removed the stored procedures I was transfering and overwriting in the destination server (ie, it did not transfer them from the source DB to the destination DB, and it completely deleted them from the destination DB.)
It also overwrote the data in the dependent tables of these stored procedures on the destination server.ie although NO tables were checked to be transferred, ONLY stored procedures, the data in the tables that the stored procedures were overwritten in the destination DB with the data from the source DB.
No other objects were selected, except the stored procedures. The dependency option was selected.
The default options were selected, except transfer all objects and use default options.
Is there a log somewhere on the server where I can find out what went wrong?
Does anyone have any ideas what happened?
Please HELP as I lost quite a lot of data.
thanx in advance
K
For some reason it removed the stored procedures I was transfering and overwriting in the destination server (ie, it did not transfer them from the source DB to the destination DB, and it completely deleted them from the destination DB.)
It also overwrote the data in the dependent tables of these stored procedures on the destination server.ie although NO tables were checked to be transferred, ONLY stored procedures, the data in the tables that the stored procedures were overwritten in the destination DB with the data from the source DB.
No other objects were selected, except the stored procedures. The dependency option was selected.
The default options were selected, except transfer all objects and use default options.
Is there a log somewhere on the server where I can find out what went wrong?
Does anyone have any ideas what happened?
Please HELP as I lost quite a lot of data.
thanx in advance
K