[dba-SQLServer] [dba-VB] MyMovieCollection database

Is the application already using this MDF?, if so it must already attached 
to a diffrent sql server instance... I'm just asking here :)

You could always just attach the database via QA as

EXEC sp_attach_db @dbname = N'pubs', 
   @filename1 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs.mdf', 
   @filename2 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs_log.ldf'



or if all you have is the mdf, 

EXEC sp_attach_single_file_db @dbname = 'pubs', 
   @physname = 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs.mdf'



On 9/5/05, Nancy Lytle <word_diva at hotmail.com> wrote:
> 
> 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 <http://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 <http://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 Bobby Heid
> Sent: Monday, August 29, 2005 11:33 AM
> To: dba-vb at databaseadvisors.com
> Subject: RE: [dba-VB] VB.Net - RSS reader - I have success...
> 
> 
> Cool! Thanks John.
> 
> Bobby
> 
> -----Original Message-----
> From: dba-vb-bounces at databaseadvisors.com
> [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of John W. Colby
> Sent: Wednesday, August 24, 2005 7:11 PM
> To: dba-vb at databaseadvisors.com
> Subject: [dba-VB] VB.Net - RSS reader - I have success...
> 
> 
> Well, I have a vb.net <http://vb.net> program reading an rss feed and 
> storing fields in a
> table. Cooool stuff. When I'm finished massaging the code I'll post it to
> show how I did it.
> 
> John W. Colby
> www.ColbyConsulting.com <http://www.ColbyConsulting.com>
> 
> _______________________________________________
> dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vb
> http://www.databaseadvisors.com
> 
> 
> 
> 
> _______________________________________________
> dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vb
> http://www.databaseadvisors.com
> 
> 
> 
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> 
> --
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.0.344 / Virus Database: 267.10.18/89 - Release Date: 9/2/2005
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> 


-- 
-Francisco
http://pcthis.blogspot.com |PC news with out the jargon!
http://sqlthis.blogspot.com | Tsql and More...