Importing data files into new instance of SQL Server

Hi Everyone,
I've got an .MDF file (database) and an .LDF file (transaction log) that
were created using SQL Server 7.0. We've built a new windows server with
SQL Server 2000 installed and would like to import the files onto that
server. The problem is that we just have the files, the SQL Server 7.0
instance is gone. What is the simplest way to create a new database on the
SQL Server 2000 box with those files?
Thanks in Advance,
Jon
if the files were previously detached from the db using sp_detach_db
you can just attach them using sp_attach_db. SQL Server should
do the upgrading for you. Of course, you'll need to drop and re-add
any users and roles.
"Jon Westmore" <westmoj@.reidhosp.com> wrote in message
news:%23c8rSoq7EHA.936@.TK2MSFTNGP12.phx.gbl...
> Hi Everyone,
> I've got an .MDF file (database) and an .LDF file (transaction log) that
> were created using SQL Server 7.0. We've built a new windows server with
> SQL Server 2000 installed and would like to import the files onto that
> server. The problem is that we just have the files, the SQL Server 7.0
> instance is gone. What is the simplest way to create a new database on
the
> SQL Server 2000 box with those files?
> Thanks in Advance,
> Jon
>

Importing data files into new instance of SQL Server

Hi Everyone,
I've got an .MDF file (database) and an .LDF file (transaction log) that
were created using SQL Server 7.0. We've built a new windows server with
SQL Server 2000 installed and would like to import the files onto that
server. The problem is that we just have the files, the SQL Server 7.0
instance is gone. What is the simplest way to create a new database on the
SQL Server 2000 box with those files?
Thanks in Advance,
Jonif the files were previously detached from the db using sp_detach_db
you can just attach them using sp_attach_db. SQL Server should
do the upgrading for you. Of course, you'll need to drop and re-add
any users and roles.
"Jon Westmore" <westmoj@.reidhosp.com> wrote in message
news:%23c8rSoq7EHA.936@.TK2MSFTNGP12.phx.gbl...
> Hi Everyone,
> I've got an .MDF file (database) and an .LDF file (transaction log) that
> were created using SQL Server 7.0. We've built a new windows server with
> SQL Server 2000 installed and would like to import the files onto that
> server. The problem is that we just have the files, the SQL Server 7.0
> instance is gone. What is the simplest way to create a new database on
the
> SQL Server 2000 box with those files?
> Thanks in Advance,
> Jon
>

Importing data files into new instance of SQL Server

Hi Everyone,
I've got an .MDF file (database) and an .LDF file (transaction log) that
were created using SQL Server 7.0. We've built a new windows server with
SQL Server 2000 installed and would like to import the files onto that
server. The problem is that we just have the files, the SQL Server 7.0
instance is gone. What is the simplest way to create a new database on the
SQL Server 2000 box with those files?
Thanks in Advance,
Jonif the files were previously detached from the db using sp_detach_db
you can just attach them using sp_attach_db. SQL Server should
do the upgrading for you. Of course, you'll need to drop and re-add
any users and roles.
"Jon Westmore" <westmoj@.reidhosp.com> wrote in message
news:%23c8rSoq7EHA.936@.TK2MSFTNGP12.phx.gbl...
> Hi Everyone,
> I've got an .MDF file (database) and an .LDF file (transaction log) that
> were created using SQL Server 7.0. We've built a new windows server with
> SQL Server 2000 installed and would like to import the files onto that
> server. The problem is that we just have the files, the SQL Server 7.0
> instance is gone. What is the simplest way to create a new database on
the
> SQL Server 2000 box with those files?
> Thanks in Advance,
> Jon
>

Importing and Exporting of XML Files (as Instance Data) in SQL Server 2000

Hello,
I have a SQL Server 2000 Database that feature individual records
which are stored in a table with data (essentially a large XML file
full of data) in the InstanceData field as XML.
I would appreciate it if someone could place some code that
demonstrates how to do importing and exporting? For 2 simple examples:
- Importing to a Excel Spreadsheet
- Export from a Excel Spreadsheet
Your sample code would be very much appreciated.
Also, is it possible to simply configure a ODBC Data Source for
linkage to other databases or applications?
Thank you for your kind support and assistance.
Cheers,
Colin.
You may get a better answer if you as this information in the Excel specific
newsgroup.
The data can easily be retrieved from the database or stored there. The main
issue will be to hook it up with Excel for which you will need an Excel
expert...
Best regards
Michael
"Colin Sheppard" <luddite1812@.yahoo.com> wrote in message
news:c652818c.0412010324.6ff80edd@.posting.google.c om...
> Hello,
> I have a SQL Server 2000 Database that feature individual records
> which are stored in a table with data (essentially a large XML file
> full of data) in the InstanceData field as XML.
> I would appreciate it if someone could place some code that
> demonstrates how to do importing and exporting? For 2 simple examples:
> - Importing to a Excel Spreadsheet
> - Export from a Excel Spreadsheet
> Your sample code would be very much appreciated.
> Also, is it possible to simply configure a ODBC Data Source for
> linkage to other databases or applications?
> Thank you for your kind support and assistance.
> Cheers,
> Colin.