Northwind in SqlExpress2005

[Alberto]

I have a script of the database Northwind for sql server 2000 but now I'd
like to use it in the sqlserver express of the visual studio 2005.

How can execute this script to create northwind in the sqlserver express?
Thank you very, very much.

[Carlos S]

You can use osql, or you can download the SQL Server Management Studio Express (SSMSE)...I you use osql, then it would be something like "osql -S (local) -E -i C:\foo.sql" at the command prompt. You can download SSMSE at http://msdn2.microsoft.com/en-us/library/ms365247.aspx

Carlos S

[Mr. Arnold]

"Alberto" <al*****@nospam .eswrote in message
news:%2******** ********@TK2MSF TNGP03.phx.gbl. ..

>I have a script of the database Northwind for sql server 2000 but now I'd
like to use it in the sqlserver express of the visual studio 2005.

How can execute this script to create northwind in the sqlserver express?
Thank you very, very much.

All you need to do is attach the Northwind database for tables like Pubs and
Authors, etc, etc. in SQL Server 2005 Management. That's all I did was find
the Pubs and Authors tables, etc, ect the MS SQL 2000 version of tables the
MDF and LDF files, downloaded them and simply attached the to Sql Server
2005 Express. If you use Google, you should be to find that articles on how
to download and attach the tables.