sql server 2000 sample scripts

3 Aug 2006 9:10 PM

Jon Paal

I installed
Northwind and pubs Sample Databases for SQL Server 2000
but it didn't say where they were installed. How can I attach them to the database without knowing their location ?

3 Aug 2006 9:21 PM

Arnie Rowland

Using explorer, do a search for files with the extension *.mdb. Then when
you find Northwind_data.mdb, you will know where they are located.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

Show quote

"Jon Paal" <Jon[ nospam ]Paal @ everywhere dot com> wrote in message
news:OUPzPF0tGHA.2020@TK2MSFTNGP03.phx.gbl...
>I installed
> Northwind and pubs Sample Databases for SQL Server 2000
> but it didn't say where they were installed. How can I attach them to the
> database without knowing their location ?
>
>
>

3 Aug 2006 10:30 PM

Erland Sommarskog

Jon Paal (Jon[ nospam ]Paal @ everywhere dot com) writes:

> I installed
> Northwind and pubs Sample Databases for SQL Server 2000
> but it didn't say where they were installed. How can I attach them to
> the database without knowing their location ?

Mine are under
E:\Program Files\Microsoft SQL Server 2000 Sample Database Scripts.
(Yours might be on C, if that is your system drive.)

They are not mdf files, but SQL files that you run.

--
Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx