[MSSQL] MSSQL2000 ->2005 마이그레이션 attach

-- DB MSSQL attach
sp_attach_db @dbname = 'AMAILCS',
@filename1 = 'D:\MSSQL\Data\AmailCS\AMAILCS_Data.MDF',
@filename2 = 'D:\MSSQL\Log\AmailCS\AMAILCS_Log.LDF'

sp_attach_db @dbname = 'AMAILCS_DEV',
@filename1 = 'D:\MSSQL\Data\AmailCS_Dev\AMAILCS_DEV_Data.MDF',
@filename2 = 'D:\MSSQL\Log\AmailCS_Dev\AMAILCS_DEV_Log.LDF'

sp_attach_db @dbname = 'AMAILCSNEW',
@filename1 = 'D:\MSSQL\Data\AmailCS_New\AMAILCSNEW_Data.MDF',
@filename2 = 'D:\MSSQL\Log\AmailCS_New\AMAILCSNEW_Log.LDF'

sp_attach_db @dbname = 'CS',
@filename1 = 'D:\MSSQL\Data\CS\CS_Data.MDF',
@filename2 = 'D:\MSSQL\Log\CS\CS_Log.LDF'

sp_attach_db @dbname = 'EMS51_BMT',
@filename1 = 'D:\MSSQL\Data\EMS51_BMT\EMS51_BMT_Data.MDF',
@filename2 = 'D:\MSSQL\Log\EMS51_BMT\EMS51_BMT_Log.LDF'

sp_attach_db @dbname = 'EMS_BMT',
@filename1 = 'D:\MSSQL\Data\EMS_BMT\EMS_BMT_Data.MDF',
@filename2 = 'D:\MSSQL\Log\EMS_BMT\EMS_BMT_Log.LDF'

------------------------------------------------

-- 데이터베이스 권한
use ems51_bmt
exec sp_change_users_login 'Update_One', 'ems51_bmt', 'ems51_bmt'

use ems_bmt
exec sp_change_users_login 'Update_One', 'ems_bmt', 'ems_bmt'