Nancy Lytle
word_diva at hotmail.com
Mon Sep 5 12:01:55 CDT 2005
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 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 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 _______________________________________________ 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