Require permission to the SQL2000 server (adding your SQL 2008 service account to the local admins on the SQL 2000 server would normally suffice as buy default, local admins have admin access.)
Everything that follows is done on the SQL 2008 box
1: Start → All Programs → Microsoft SQL Server 2008 → Import and Export Data (64-bit)
2: Welcome to SQL Server Import and Export Wizard → Next
3: Choose a Data Source →
Data Source → SQL Server Native Client 10.0
Server name → << Name of your remote SQL 2000 server and instance name >>
Database → << Name of the database to be imported >>
4: Choose a Destination →
Destination → SQL Server Native Client 10.0
Server name → (local)
Data → << Use existing name or create new name for imported database >>
5: Specify Table Copy or Query →
'Copy data from one or more tables or views
6: Select Source Tables and Views →
Select all 'Tables and views'
7: Save and Run Package →
Check 'Run immediately'
8: Complete the Wizard → Finish
9: Performing Operation →
Wait for it to complete, click 'Close,' and it's done.
Author - V. Cosonok