Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 AdventureWorks database

Author  Topic 

tadin
Yak Posting Veteran

63 Posts

Posted - 2007-03-21 : 16:05:58
I'm interested in AdventureWorks querying. I thought of get a start from someone specifically on this db.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-03-21 : 16:27:26
What is your question?

Tara Kizer
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2007-04-03 : 14:45:45
I'll take over this thread...I just installed AdventureWorks but I can't see it in SSMS...what gives?

I can see the mdf and ldf in folder separate from the other databases on that folder, I was thinking of copying them to the other folder, but that doesn't make much sense

Any ideas?

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2007-04-03 : 14:52:07
Never mind

exec sp_attach_db @dbname=N'AdventureWorks'
, @filename1=N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks_Data.mdf'
, @filename2=N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks_log.ldf'

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-04-03 : 15:05:03
quote:
Originally posted by X002548

I'll take over this thread
He's all yours



Peter Larsson
Helsingborg, Sweden
Go to Top of Page
   

- Advertisement -