Hmm, I don't have SQL Server Studio Express, but a quick search found an answer that seems promising:
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Serv er-2005/Q_22862475.html#a19987782 There's also a command-line way to do it: http://msdn.microsoft.com/en-us/library/ms165673.aspx That shows use of a CREATE DATABASE FOR ATTACH command in SQL. Hope that helps. /charlie From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dusty Hale Sent: Wednesday, June 11, 2008 12:36 PM To: [email protected] Subject: RE: [ACFUG Discuss] OT: problem with IIS on XP Pro. SQL Studio Express doesn't seem to let me change the file names to point to the data files. _____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charlie Arehart Sent: 06/11/2008 11:47 AM To: [email protected] Subject: RE: [ACFUG Discuss] OT: problem with IIS on XP Pro. Well, if you install Express on the same machine that had the eval, the new Express edition could read the SQL Server files (MDF, LDF) that were created there. No need to import/export. You'd just create the DB new in Express but point it at the existing files. I'm pretty sure that would work. Anyone know for sure? /charlie From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dusty Hale Sent: Wednesday, June 11, 2008 11:04 AM To: [email protected] Subject: RE: [ACFUG Discuss] OT: problem with IIS on XP Pro. I found a work around for now by creating a copy of the live database on my VPS server at HostMySite. Not a great way to develop but will get me by for now. I think you're right the best thing would be to just install express. I just wonder how I ended up installing the eval in the first place LOL. My only thought was that if I purchased a license and applied it to the eval, then I could revive the database. If I install express, I don't think it has any kind of import export abilities so I wasn't yet sure how I would pull down the data from the live database. I have a license for Red Gate so I will likely install that and use it to synch the data. Thanks everyone for listening to my desperate pleas for help. I suppose it could be much worse LOL. Dusty ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink <http://www.fusionlink.com> ------------------------------------------------------------- ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink <http://www.fusionlink.com> ------------------------------------------------------------- ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
