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

How to concatenate strings from a column into a single row (with NULL value)?
Single to Multiple columns
Assistance with SQL Script
SQL 2005: Why does DECLARE varchar(MAX) in Stored Procedure not work?
HOW TO: PIVOT for unknown number of column headings?