[dba-SQLServer] MyMovieCollection database

John,

Since it is the "Express" version, you are out of luck.
There is no UI.  EM will not work with SQL Express.

The best thing to do is to create the ALTER TABLE statements
and use ADO to execute them against the database.

Robert

At 10:03 AM 9/6/2005, you wrote:
>Date: Mon, 5 Sep 2005 13:01:55 -0400
>From: "Nancy Lytle" <word_diva at hotmail.com>
>Subject: Re: [dba-SQLServer] [dba-VB] MyMovieCollection database
>To: <dba-sqlserver at databaseadvisors.com>
>Message-ID: <BAY106-DAV16B114141252EDD227D9DE84A40 at phx.gbl>
>Content-Type: text/plain;       charset="windows-1250"
>
>Have you tried creating a new database in EM, using the same name, and then
>do a restore using the MovieDatabase mdf?
>
>Nancy
>
>-----Original Message-----
>From: dba-sqlserver-bounces at databaseadvisors.com
>[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of John W.
>Colby
>Sent: Monday, September 05, 2005 9:55 AM
>To: dba-vb at databaseadvisors.com; 'SQLServer'
>Subject: Re: [dba-SQLServer] [dba-VB] MyMovieCollection database
>
>I cannot attach the database using enterprise manager.  When I try to do so,
>it opens a find dialog, which I use to find the movie database.  As soon as
>I select the database, I get an "attach as" down in the bottom of the
>dialog, but it is "hardwired" for D:\... Which is a CD drive on my laptop.
>If I attempt to change the D:\ to C:\ the "OK" button grays out and I am no
>longer allowed to continue.
>
>So little time, so much time wasted trying to get Microsoft stuff to work.
>
>John W. Colby
>www.ColbyConsulting.com
>
>Contribute your unused CPU cycles to a good cause:
>http://folding.stanford.edu/
>
>-----Original Message-----
>From: dba-vb-bounces at databaseadvisors.com
>[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of John W. Colby
>Sent: Monday, September 05, 2005 9:34 AM
>To: bheid at appdevgrp.com; dba-vb at databaseadvisors.com; SQLServer
>Subject: [dba-VB] MyMovieCollection database
>
>
>The starter kit for VB Express called MyMovieCollection appears to be
>working, however one of the fields in the SQL Server database is too short -
>the WebPageLink field.  This database is used by the application but AFAICT
>I am not given any tools to work with the database itself.  If this were in
>Access I would just open it and modify the length of the field and be done,
>but this is SQL Server.
>
>Can anyone tell me how to "attach" to this SQL Server database using SQL
>Enterprise manager so that I can make the mod necessary to allow this to
>work?
>
>John W. Colby
>www.ColbyConsulting.com