New to SQL 1

[Guest_imported]

We have recently installed SQL Server 7 and have been given a DB file containing all of the SQL statements--tables, etc. The problem is that none of us has a clue how to create a DB with that information. We have searched the Help files but unfortunately, we don't know what we are looking for. Is there anyone who can guide us in the right direction (I don't want to hear "hire someone else!!!&quot

 

[foxdev]

have been given a DB file

What exactly were you given? A file with an MDF extension? A BAK extension? Robert Bradley

http://www.lowcostprints.com

http://www.foxdev.com

 

[Guest_imported]

it has the extention .sql

 

[ColinM]

Sounds like a script which is just a plain text file containing commands to create the database. Try loading it up in Query Analyser and then if all looks okay hit F5 to execute it.
Then load up Enterprise Manager and check for a new database.

 

[Guest_imported]

You 'da man!!! That seemed to work like a charm. Thanks a lot for your help.