I am having problems copying views from one SQL 2000 DB to
another DB (I have just created) on the same server using
DTS. I am setting up a test DB. The tables copy fine and I
can't understand why the views will not. There is no error
message other than 'error occured'.

Could someone please provide me with a list of likely
things to check for or a way of finding out exactly what's
failing. Apologises for the basic level of this question
but the help files aren't much use on this.

Craig,

If you want a complete copy of the db then you would be better off either
restoring a full backup or using sp_attach_db. If you just want views (or
any particular objects) simply script them using EM and run that script on
the other server. But in any case here are some associated links including
one for the copy wizard issues.


http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scri...p?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server

http://www.support.microsoft.com/?id=274463 Copy DB Wizard issues


--
Andrew J. Kelly SQL MVP


"Craig" <anonymous (AT) discussions (DOT) microsoft.com> wrote