Cara 1: 1. Jalankan Enterprise Manager 2. Klik tanda tambah SQL Server Group 3. Klik tanda tambah group server (nama instance) 4. Klik kanan mouse pada group server, pilih menu All Tasks, kemudian klik Copy Database Wizard dan ikuti pentujuk pada layar5. Jalankan Query Analyzer dan eksekusi skrip di bawah ini: USE pubs EXEC sp_updatestats
Cara 2 Attach Database Saya juga pernah langsung melakukan attach database (juga berhasil):1. Jalankan Enterprise Manager 2. Klik tanda tambah SQL Server Group 3. Klik tanda tambah group server (nama instance) 4. Klik kanan mouse pada group serve, pilih menu All Tasks->Attach Datase... Rgds, www.uchan.or.id > maaf yah, > > ada yg tahu, > bagaimana cara paling mudah untuk > upgrade MS SQL Server7 ke MS SQL Server2000. > > trimakasih untuk bantuannya ___________________________________________________________ indomail - Your everyday mail - http://indomail.indo.net.id ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/NhFolB/TM --------------------------------------------------------------------~-> ----------------------------------------------- INDOPB TURUT BERDUKA CITA UNTUK ACEH & SUMUT ----------------------------------------------- IndoPB - Indonesia PB User Group To Post a message, send it to: [EMAIL PROTECTED] To Unsubscribe,send a blank message to: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indopb/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
