Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Contest 200401 - Try SQLCompare from Red Gate Expand / Collapse
Author
Message
Posted Sunday, January 25, 2004 3:26 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Yesterday @ 7:46 AM
Points: 6,784, Visits: 1,898

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



Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #97128
Posted Wednesday, January 28, 2004 8:00 AM
SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,039, Visits: 1
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!
Post #97674
Posted Wednesday, January 28, 2004 9:43 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, September 3, 2007 10:17 PM
Points: 210, Visits: 1
is it open to us on the other side of the globe (Australia?) sure hope so !!


------------------------------
Life is far too important to be taken seriously
Post #97848
Posted Thursday, January 29, 2004 9:53 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, July 21, 2014 12:53 PM
Points: 16, Visits: 131

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.




Post #97953
Posted Friday, January 30, 2004 8:09 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, November 10, 2004 7:56 AM
Points: 94, Visits: 1

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.




Post #98144
Posted Thursday, February 5, 2004 6:29 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, April 27, 2004 7:58 AM
Points: 10, Visits: 1

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




Post #98843
Posted Thursday, February 5, 2004 7:26 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Yesterday @ 7:46 AM
Points: 6,784, Visits: 1,898

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.

 



Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #98976
Posted Thursday, February 5, 2004 7:27 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Yesterday @ 7:46 AM
Points: 6,784, Visits: 1,898
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.

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #98977
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse