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 |
|
elango_ara
Starting Member
1 Post |
 Posted - 2002-08-21 : 15:05:02
|
| Import wizard gives error only when copying views or stored procs from sqlserver7 to sqlserver2000. No problems copying tables. Error as follows "FAILED TO COPY OBJECTS FROM MICROSOFT SQL SERVER TO MICROSOFT SQL SERVER" |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-08-21 : 15:47:38
|
| When that error comes up, after you click OK, you should be able to double-click on the line that failed and get more detailed error information. Please post that additional info. |
 |
|
|
royv
Constraint Violating Yak Guru
455 Posts |
Posted - 2002-08-21 : 15:49:48
|
| For views and stored procedures, would it not be easy enough to manually script it out and compile them on the SQL 2000 box? You might want to go this route instead of using the wizard. Also there is an article on SQLTeam regarding upgrading from SQL 7 to 2000, it is here:http://www.sqlteam.com/item.asp?ItemID=9066*************************Someone done told you wrong! |
|
|
|
|
|
|
import wiz error copying sprocs from sql7 to 2000