How to create a database on pendrive using MSSQL 7.0??

[Vikram Jain]

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]

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/default...b;EN-US;224071

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

John
"Vikram Jain" <vi*******@hotmail.com> wrote in message
news:41**********************@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!

[Erland Sommarskog]

John Bell (jb************@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, es****@sommarskog.se

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