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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 opening database directly from dvd

Author  Topic 

chentiangemalc
Starting Member

2 Posts

Posted - 2006-07-15 : 17:30:31
Hi,

I have a datbase created on SQL Server 2000 machine via 3rd party software which contains historical statistical data and is archived off to DVD.
The dvd contains .NDF, .LDF, .MDF files...

The database is not marked read only (in the database properties) and I'm unable to change that...

Is there no way to open it without copying to the harddisk?

I want to make a program to quickly view the data, but at the moment it seems I must copy it to the harddrive first...and the file is about 3 GB so it would really slow down the program...

I'm using SQL Server 2005 Express + VB 2005 at the moment

Would appreciate any ideas...


Chentiangemalc
Microsoft Certified Systems Administrator: Messaging (Windows 2003 Server)
Certified Novell Netware Administrator
A+ Technician

nr
SQLTeam MVY

12543 Posts

Posted - 2006-07-15 : 18:38:25
see
sp_create_removable

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -