Shahid Khan

Shahid Khan

  • NA
  • 1
  • 0

SQLDMO AttachDB

Feb 27 2007 6:43 AM
Hi... I'm trying to attach a database programmatically, but I keep getting the error: "Device activation error. The physical filename may be incorrect". I've read other posts regarding this error and they all have to do with using multistrings. The path to the filename that I'm using does not contain any spaces and I've even enclosed it in square brackets "[]" as suggested, but I still get this error. It works perfectly if I attach the db in EM. The mdf file is not ReadOnly. AttachDBWithSingleFile doesn't give me any errors but fails to attach the db. I'm using SQLServer 2000 and VS.net 2003 Any help will be really appreciated.