SQLServerCentral / Contests! / SQLServerCentral.com / Contest 200401 - Try SQLCompare from Red Gate / Latest Posts

RE: Contest 200401 - Try SQLCompare from Red Gate

Andy Warren — Thu, 05 Feb 2004 19:27:00 GMT

Anyone else had problems attaching? I've had quite a few successful attempts judging by entries received so I dont think the files themselves are bad.

RE: Contest 200401 - Try SQLCompare from Red Gate

Andy Warren — Thu, 05 Feb 2004 19:26:00 GMT

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.

RE: Contest 200401 - Try SQLCompare from Red Gate

SvenL — Thu, 05 Feb 2004 06:29:00 GMT

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....

RE: Contest 200401 - Try SQLCompare from Red Gate

McDonB — Fri, 30 Jan 2004 08:09:00 GMT

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 1Could 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.

RE: Contest 200401 - Try SQLCompare from Red Gate

hmaandekok — Thu, 29 Jan 2004 09:53:00 GMT

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

GOCREATE DATABASE pubsdevON PRIMARY (FILENAME = 'c:\dba\redgate\pubsdev.mdf')FOR ATTACHGO

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 1Could 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.

RE: Contest 200401 - Try SQLCompare from Red Gate

adamcrv — Wed, 28 Jan 2004 21:43:00 GMT

is it open to us on the other side of the globe (Australia?) sure hope so !!

Contest 200401 - Try SQLCompare from Red Gate

Site Owners — Wed, 28 Jan 2004 08:00:00 GMT

No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!

Contest 200401 - Try SQLCompare from Red Gate

Andy Warren — Sun, 25 Jan 2004 15:26:00 GMT

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