Re: Trying to Install AdventureWorks in SQL 2005

simple. databases can be in any folder on your computer.

with that said, simply go to the databases node in the tree, right click and use the ATTACH option, then sepecify the folder where you have the adventureworks. if you want to move it, then move it before attaching.



Henry Jones wrote:
I went to Microsoft downloads and downloaded the AdventureWorks.msi file. When it ran, it says that it installed AdventureWorks.

I think I have SQL 2005 Express and SQL 2005 on my PC. There are two directories: C:\Program Files\Microsoft SQL Server\MSSQL\Data
and C:\Program Files\Microsoft SQL Server\MSSQL.1\Data

The AdventureWorks has been placed in the C:\Program Files\Microsoft SQL Server\MSSQL.1\Data directory, but when I bring up SQL Server Management Studio, I don't see AdventureWorks. The databases I have associated with this are all under the C:\Program Files\Microsoft SQL Server\MSSQL\Data directory.

How can I import the table into SQL server and why did the MSI install put it in the wrong place.

Thanks for any guidence and help on this "day before Thanksgiving"



.

Relevant Pages

  • Re: BizTalk eating up SQL Server (Virii Behaviour)
    ... Yes, one gig is the least to run sql & bts in the same box, ... uninstall procedure, i manually deleted all databases, and run the ... and it was leaving like 20 mbs free memory, ... BizTalk Solution Developer ...
    (microsoft.public.biztalk.general)
  • Re: Dont understand what version of SQL to install
    ... I'm talking about developing and testing databases for my client and ... To my XP, I can add SQL Developer 2008 to develop (I guess I should say, ... So I can use SQL Developer 2008 to create a database in standard 2005, ... installed on Client OSs such as Windows Vista. ...
    (microsoft.public.sqlserver.setup)
  • Re: Relational-to-OOP Tax
    ... Many SQL vendors has text mining features. ... Tutorial D isn't availible in production databases. ... The Third Manifesto,2 object functionality and the relational model are ...
    (comp.object)
  • Re: [PHP] is there a problem with php script pulling HTML out of database as it writes the page??
    ... I even had one tell me "SQL injection? ... about databases, server management, mail, or anything. ... I have a ghostwriter who keeps me active on the mailing lists. ...
    (php.general)
  • DataArchitect Version 3.5 Now On HP-UX
    ... DataArchitect is a powerful tool that provides ERD capability like PowerDesigner as well as the ability to graphically reverse engineer, create and modify a database through ODBC and perform advanced SQL functions. ... Data Architect is an emerging enterprise tool for designing databases at all levels of an organization using the same concepts found in tools costing thousands of dollars! ... Minimize/Maximize feature on diagram objects ...
    (comp.sys.hp.mpe)
Loading