How to create a database on pendrive using MSSQL 7.0?

Hey friends,
I want create a database on a usb pendrive and acess it my server is
MSSQL 7.0 when ever i plugin the pend drive.
Please let me know the the procedure .. this is a chellenging job..
Thank You
regards

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!Hi

SQL Server does not support plug and play in such a way. There is a means to
create databases on removable media (avaiable in SQL 2000 but I can't check
SQL 7) called sp_create_removable, which is aimed at distributing databases
on read only media.

Therefore you will have to manually make sure that the database was
detached/attached correctly
http://support.microsoft.com/defaul...kb;EN-US;224071

Personally I would only store a backup on removably media like this and
overwrite/restore it when necessary.

John

"Vikram Jain" <vicky_j77@.hotmail.com> wrote in message
news:4143f445$0$26124$c397aba@.news.newsgroups.ws.. .
> Hey friends,
> I want create a database on a usb pendrive and acess it my server is
> MSSQL 7.0 when ever i plugin the pend drive.
> Please let me know the the procedure .. this is a chellenging job..
> Thank You
> regards
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!|||John Bell (jbellnewsposts@.hotmail.com) writes:
> SQL Server does not support plug and play in such a way. There is a
> means to create databases on removable media (avaiable in SQL 2000 but I
> can't check SQL 7) called sp_create_removable, which is aimed at
> distributing databases on read only media.

I made a quick check, and sp_create_removable is available on SQL7.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp