Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tkizer
Almighty SQL Goddess
38200 Posts |
 Posted - 2003-06-20 : 13:50:10
|
| Has anyone ever used sp_certify_removable or sp_create_removable? My boss was looking for something in BOL and came upon these two system stored procedures. We are in the process of shipping one of our applications to a customer and need to get the database to them. We were considering backup/restore, detach/attach, or installation scripts using osql. I have read what BOL says about the stored procedures but it really doesn't provide a lot of information. BOL made it sound like that sp_create_removable was the way to go to ship the database on a CD. Has anyone does this before? sp_create_removable creates three files. What do you do with these three files on the destination server? I'm probably going to use the detach/attach method but I always like to know what the alternatives are.Tara |
|
|
Shastryv
Posting Yak Master
145 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-06-26 : 13:50:56
|
| Thanks for the info Shastryv.Tara |
 |
|
|
|
|
|
sp_certify_removable and sp_create_removable