EXEC sp_detach_db 'ASPState','true';
EXEC sp_detach_db 'BloodDonation','true';
EXEC sp_detach_db 'Billing','true';
EXEC sp_detach_db 'build_file','true';
EXEC sp_detach_db 'Cardio','true';
EXEC sp_detach_db 'Clinical_Area','true';
EXEC sp_detach_db 'Doctors','true';
EXEC sp_detach_db 'Hemodialysis','true';
EXEC sp_detach_db 'History','true';
EXEC sp_detach_db 'Inventory','true';
EXEC sp_detach_db 'Laboratory','true';
EXEC sp_detach_db 'Medicare','true';
EXEC sp_detach_db 'MSys','true';
EXEC sp_detach_db 'Nuclear','true';
EXEC sp_detach_db 'Password','true';
EXEC sp_detach_db 'Patient_DATA','true';
EXEC sp_detach_db 'Payroll','true';
EXEC sp_detach_db 'Prepaid','true';
EXEC sp_detach_db 'Radiology','true';
EXEC sp_detach_db 'Register','true';
EXEC sp_detach_db 'Reports','true';
EXEC sp_detach_db 'Schedule','true';
EXEC sp_detach_db 'Station','true';
EXEC sp_detach_db 'Dicom','true';
EXEC sp_detach_db 'PACS','true';
EXEC sp_detach_db 'dbRecords','true';
EXEC sp_detach_db 'FixedAsset','true';
EXEC sp_detach_db 'Medicare','true';
EXEC sp_detach_db 'Transplant','true';
EXEC sp_detach_db 'MedSMS','true';

EXEC sp_attach_db @dbname = N'ASPState', 
   @filename1 = N'C:\MedsysV4\DATA\ASPState.mdf', 
   @filename2 = N'C:\MedsysV4\DATA\ASPState_Log.ldf';

EXEC sp_attach_db @dbname = N'BloodDonation', 
   @filename1 = N'C:\MedsysV4\DATA\BloodDonation.mdf', 
   @filename2 = N'C:\MedsysV4\DATA\BloodDonation_Log.ldf';

EXEC sp_attach_db @dbname = N'Build_File', 
   @filename1 = N'C:\MedsysV4\DATA\Build_File.mdf', 
   @filename2 = N'C:\MedsysV4\DATA\Build_File_Log.ldf';

EXEC sp_attach_db @dbname = N'Billing', 
   @filename1 = N'C:\MedsysV4\DATA\Billing.mdf', 
   @filename2 = N'C:\MedsysV4\DATA\Billing_log.ldf';

EXEC sp_attach_db @dbname = N'Cardio', 
   @filename1 = N'C:\MedsysV4\DATA\Cardio.mdf', 
   @filename2 = N'C:\MedsysV4\DATA\Cardio_Log.ldf';

EXEC sp_attach_db @dbname = N'Clinical_Area', 
   @filename1 = N'C:\MedsysV4\DATA\Clinical_Area.mdf', 
   @filename2 = N'C:\MedsysV4\DATA\Clinical_Area_Log.ldf';

EXEC sp_attach_db @dbname = N'Doctors', 
   @filename1 = N'C:\MedsysV4\DATA\Doctors.mdf', 
   @filename2 = N'C:\MedsysV4\DATA\Doctors_Log.ldf';

EXEC sp_attach_db @dbname = N'Hemodialysis', 
   @filename1 = N'C:\MedsysV4\DATA\Hemodialysis.mdf', 
   @filename2 = N'C:\MedsysV4\DATA\Hemodialysis_Log.ldf';

EXEC sp_attach_db @dbname = N'History', 
   @filename1 = N'C:\MedsysV4\DATA\History.mdf', 
   @filename2 = N'C:\MedsysV4\DATA\History_Log.ldf';

EXEC sp_attach_db @dbname = N'Inventory', 
   @filename1 = N'C:\MedsysV4\DATA\Inventory.mdf', 
   @filename2 = N'C:\MedsysV4\DATA\Inventory_Log.ldf';

EXEC sp_attach_db @dbname = N'Laboratory', 
   @filename1 = N'C:\MedsysV4\DATA\Laboratory.mdf', 
   @filename2 = N'C:\MedsysV4\DATA\Laboratory_Log.ldf';

EXEC sp_attach_db @dbname = N'Medicare', 
   @filename1 = N'C:\MedsysV4\DATA\Medicare.mdf', 
   @filename2 = N'C:\MedsysV4\DATA\Medicare_Log.ldf';

EXEC sp_attach_db @dbname = N'MSys', 
   @filename1 = N'C:\MedsysV4\DATA\MSys.mdf', 
   @filename2 = N'C:\MedsysV4\DATA\MSys_Log.ldf';

EXEC sp_attach_db @dbname = N'Nuclear', 
   @filename1 = N'C:\MedsysV4\DATA\Nuclear.mdf', 
   @filename2 = N'C:\MedsysV4\DATA\Nuclear_Log.ldf';

EXEC sp_attach_db @dbname = N'Password', 
   @filename1 = N'C:\MedsysV4\DATA\Password.mdf', 
   @filename2 = N'C:\MedsysV4\DATA\Password_Log.ldf';

EXEC sp_attach_db @dbname = N'Payroll', 
   @filename1 = N'C:\MedsysV4\DATA\Payroll.mdf', 
   @filename2 = N'C:\MedsysV4\DATA\Payroll_Log.ldf';

EXEC sp_attach_db @dbname = N'Patient_DATA', 
   @filename1 = N'C:\MedsysV4\DATA\Patient_DATA.mdf', 
   @filename2 = N'C:\MedsysV4\DATA\Patient_DATA_Log.ldf';

EXEC sp_attach_db @dbname = N'Prepaid', 
   @filename1 = N'C:\MedsysV4\DATA\Prepaid.mdf', 
   @filename2 = N'C:\MedsysV4\DATA\Prepaid_Log.ldf';

EXEC sp_attach_db @dbname = N'Radiology', 
   @filename1 = N'C:\MedsysV4\DATA\Radiology.mdf', 
   @filename2 = N'C:\MedsysV4\DATA\Radiology_Log.ldf';

EXEC sp_attach_db @dbname = N'Register', 
   @filename1 = N'C:\MedsysV4\DATA\Register.mdf', 
   @filename2 = N'C:\MedsysV4\DATA\Register_Log.ldf';

EXEC sp_attach_db @dbname = N'Reports', 
   @filename1 = N'C:\MedsysV4\DATA\Reports.mdf', 
   @filename2 = N'C:\MedsysV4\DATA\Reports_Log.ldf';

EXEC sp_attach_db @dbname = N'Schedule', 
   @filename1 = N'C:\MedsysV4\DATA\Schedule.mdf', 
   @filename2 = N'C:\MedsysV4\DATA\Schedule_Log.ldf';

EXEC sp_attach_db @dbname = N'Station', 
   @filename1 = N'C:\MedsysV4\DATA\Station.mdf', 
   @filename2 = N'C:\MedsysV4\DATA\Station_Log.ldf';