Conversion Issues - SS2000 to SS2005 - using Object Method RRS feed

  • Question

  • I am converting   databases from Windows 2000 and from SQL Server 2000  to a totally new 4 processor Server 2003 with SQL SErver 2005.  I used the Database Copy Wizard in SS2005 to do the transfer.  I used the Object Method.  After making sure the databases were big enough to hold the new Masterdatabase everything went well... except none of the stored procedures from any of the databases copied from SQL Server 2000 to SQL Server 2005.  What did I do wrong?  And how do i fix it.  Also, even though I changed the default database, the wizard did not reflect the new SAN location for the Data and Log files.  I had to do each one manually.
    Monday, November 13, 2006 3:12 PM