I am using SQL Server 7 SP4.
I have created a blank database in which i am trying to import using DTS
wizard all tables/views/stored procedures without any DATA (records).
I keep getting different errors when importing the views and/or the SPs.
I've tried many things unsuccessfully.
Now even after the error msg of the DTS, i see some of the SPs under
their previous names.
In other words, let's say i have an SP called zprocDeleteProduct and
this SP was previously called procDeleteProduct.
When i check the 2nd database, i see the SP as zprocDeleteProduct
instead of seeing it as procDeleteProduct.
I have other SPs that are being imported with their previous names.
I have renamed these SPs from within Access XP. I don't create SPs
in SQL EM or SQL Query Analyzer.
How can i fix this problem? I don't want to import SPs under their previous
names.
Thank you