Dave, I didn't catch that it was an external drive - I think if it's an "external USB drive" you might be right - I was thinking more along the lines of a hot swap sata drive on a sled that plugs into a empty bay. I know with 2000 you could only do direct attached, but now days there are so many storage choices I believe they have changed that limitation.
Mike, A quick google search brought up this link: http://stackoverflow.com/questions/78560/locked-sql-server-data-files I think it relates directly to what you want to do - I would read it carefully. It seems like you might end up with ACL signiture or other file status or permission issues when spooling up these files. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -----Original Message----- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Monday, January 04, 2010 8:16 PM To: cf-talk Subject: Re: SQLServer Express and SQLServer - totally compatible? > I'm building a second machine which will run CF on it, and will need > to manipulate my SQLServer2005 databases on a network server. I'm > going to be connecting this machine to these databases on an external > drive as though they're local, because i'm going to be swapping back > and forth between these machines regularly. I dont want to keep > attaching and detatching lots of databases - i'd rather just connect > the external database to this machine and then boot it up. Honestly, I don't know if SQL Server will let you do this. I suspect it might not, as Windows can detect removable drives. > So if i have SQLServer2005 (the full version) driving the databases > when I'm working at one location, and SQLServer2005 Express driving > the databases when I'm working at my other location, will that cause > problems in the databases? Are the two versions fully compatible at > least as far as database file structure etc is concerned? Yes, you can use database files created by one with the other, although there may be some limitations if you use certain features in SQL Server 2005 when you create the database files (such as the ability to create databases larger than 4GB - that's not supported by Express). Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more inform ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329409 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4