This contest begins Jan 29, 2004 and runs through Feb 27, 2004. Details can be found at the following link:

http://www.sqlservercentral.com/contests/200401/contest.aspx

I get this message when trying to attach the mdf supplied in the download.

GO
CREATE DATABASE pubsdev
ON PRIMARY (FILENAME = 'c:\dba\redgate\pubsdev.mdf')
FOR ATTACH
GO

same results for

EXEC sp_attach_single_file_db

@dbname = 'pubsdev',   

@physname = c:\DBA\REDGATE\pubsdev.mdf'

Server: Msg 1813, Level 16, State 2, Line 1
Could not open new database 'pubsdev'. CREATE DATABASE is aborted.
Device activation error. The physical file name 'd:\ssc\MSSQL$PUBLISHER\data\PubsDev_log.ldf' may be incorrect.

Thought I would put this here, I had problems attaching the .MDF's to my local instance, since my "D:" drive was a CD-ROM, I kept getting the error:

Server: Msg 1813, Level 16, State 2, Line 1
Could not open new database 'PubsDev'. CREATE DATABASE is aborted.
Device activation error. The physical file name 'd:\ssc\MSSQL$PUBLISHER\data\PubsDev_log.ldf' may be incorrect.

So it appears even though you want it to create the Log File in another location, it fails.

I attached on another server that had a writeable "D:" drive, and it worked fine, creating the Log File where I told it to.

This is no contest... This is brainless homework...

A contest for SQL Server Central should be  more a match where all participant must think hard to build some script (or some other SQL Server based thing) that's better than someoneelse's.

This contest is brainless boring.

Sorry....

Sven,

There are contests of different kinds, I'll admit this one is not super challenging compared to some. I dont think that means its bad, just different.