June 5, 2002 at 2:47 pm
Whenever I run the copy objects, I just select stored procs, but all of the data in every table disappears....HELP!
June 5, 2002 at 3:11 pm
There are several options on the wizard that deal with data. You need to uncheck these, also there have delete and create tables on those options show be sure you uncheck anything not needed to move the SPs over. If you are lost let me know I will get the details or someone else may post them.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 5, 2002 at 3:39 pm
Thanks, but I have been very careful that I am not selecting to delete anything from the tables. It seems like there is some sort of bug.
June 5, 2002 at 6:00 pm
I havent heard of any bug that severe. Using SQL7 or SQL2K?
Andy
June 5, 2002 at 7:53 pm
Can you post your full steps and I will try to test tomorrow. Also what version of SQL are you running?
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 6, 2002 at 7:42 am
I guess that I had checked to drop and recreate all objects, but I only selected the stored procedures, thinking it would just affect them--although all of the tables were dropped and recreated without data.
June 6, 2002 at 8:36 am
Run profiler against the recieving server looking at SQL Statements and see what commands are being sent to the destination. COuld be that Wizard has a problem and is causing this or something else may point the reason.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply