An example of creating a removable database is : sp_create_removable « System Functions « SQL Server / T-SQL Tutorial






sp_create_removable sales, salessys, 'c:\sales\data\salessys.dat',3,
       saleslog,'c:\sales\data\saleslog.dat',6,
       salesdata,'c:\sales\data\salesdata.dat',20
25.28.sp_create_removable
25.28.1.An example of creating a removable database is