OK. I give up. SQL 2005 wins 1-0, this time. I created a new database with one mdf file and one ldf file and imported all the...

I have checked out SHRINKFILE and EMPTYFILE and they would work fine as long as the files were in the same filegroup. In my case, each file is in...

Then can I restore it with all the file and filegroups, back it up (somehow), and then restore it to one mdf file?

Thanks!!

Thanks Mohit!! Your suggested changes worked perfectly!

I apologize for posting in the wrong area. I honestly did not notice this was SQL 7, 2000 until you mentioned my...

OK, thanks! I guess I'll get started uninstalling and reinstalling.

But SQL 2005 doesn't give you an option to place the SQL Server files anywere else, does it?

I hope I don't have to re-install. I am trying to duplicate...

That was exactly my suspession but I checked and double checked (maybe not enough times for me LOL) but the data source = my pc name and the connections tested...

The instructions that I am following say to open up the AdventureWorks Solution (Adventure Works.sln) in SQL BIDS in the Enterprise or Standard folder of where the Samples were put....

I finally did get the AdventureWorks.mdf and AdventureWorksDW.mdf installed. Now I am having problems loading the solution (AdventrueWorks Analysis Services Project\Standard) for Analysis Services. It is giving me...

Through a miracle of modern science I noticed some instructions on the CodePlex website on how to load AdventureWorks through the Add/Remove Programs. I took a shot and tried...

Can I get just the databases for SQL 2005? I thought I only saw .msi files to download for 2005?

If I attach the data warehouse (AdventureWorksDW) will Analysis Services...

Thanks for everyone's help on this, I really appreciate your time!

I am running this (SQL Server 2005 Developer) on my company workstation (not enough hardware available to run it elsewhere)....

I did check sys.databases and no AdventureWorks databases are listed.

Also, I did reboot Windows. I am going to reboot again just in case.....

I did a search for AdventureWorks in...