I need to replicate a SQL Server 2000 database that exists in a hosted
environment with only primative web-based management tools. I have one tool
that creates a .bak file, and another tool for running queries. There seems
to be no way to automatically script the tables the way we can in Enterprise
Manager or SQL Server Management Studio.

I have never worked with .bak files. Does the .bak file contain both schema
and data, so that it can be restored into an empty SQL Server instance, or
does is contain only data?

If the .bak file contains only data, then please tell me which sql
statements I would use to write a query that will output scripts for
creating the tables. I would also appreciate any web links that may help.

Many thanks,

Keith

Upate based on multiple WHERE clauses
insert into table from stored procedure
Defrag/Reindex Table
The line between Database Developers and DBAs
Handling encryption at the application level
Passing parameter from a recordset in a Stored Procedure
Spaces in Write Statement in VB
Inserting a row into the same table?
The use of Indexes
[OT] Free 512MB USB Key