I think ive corrected it but still an error:

File activation failure. The physical file name "C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\AdventureWorks2008R2_Log.ldf" may be incorrect.

Msg 5123, Level 16, State 1, Line 1

CREATE...

Thanks i have now managed to enable this and executed the correct queries

Ive just tried that in a new query and its came back with this:

Msg 5133, Level 16, State 1, Line 1

Directory lookup for the file "C:\Database\Data\AdventureWorks2008R2_Data.mdf" failed with the...

I should also state i am running Vista on my home computer, i have followed the following: http://msftdbprodsamples.codeplex.com/wikipage?title=Database%20Installer%20Help

and i still cant find how to enable this.

Is there something i may have not installed properly?

Also does filestream have to be anabled or anything else? Ive noticed i dont seem to have filestream with the SQL...

i have just tried removing the log file and i am now given this error message:

CREATE FILE encountered operating system error 5(failed to retrieve text for this error. Reason:...

When i select the Downloaded sample DB i get this message when trying to attach:

Attach database failed for Server '*******'. (Microsoft.SqlServer.Smo)

An exception occurred while executing a Transact-SQL statement...

I have just tried to attach the downloaded database and it came up with an error?

I originally had the DB saved on my desktop so i moved it to the...

Thanks once downloaded should i select open with SQL Server 08? As tutorials ive watched the sample seems to open up differently ?

Thanks for your quick reply, should i download just the 'AdventureWorks2008R2 Data File' or the others below aswell?

Thanks Gaz thats great

Thanks again!

I will look around to see if i can get a beginners edition of the book that can talk me through the basics first, and then move onto a...

Old Hand,

Thanks alot for your reply, i will look to buy these books this week and start learning. Do you recommend any particular books?

I believe this is something i want...