Seymour,
The following command is an example on Vista. Open a command prompt and enter the following, replacing MSSmallBusiness with a unique database name and point to your .mdf and .ldf files:
OSQL -S .\MSSMLBIZ -E -Q "EXEC sp_attach_db [ at ]dbname = 'MSSmallBusiness', [ at ]filename1 = 'C:\Users\<USER>\AppData\local\Microsoft\Business Contact Manager\MSSmallBusiness.mdf', [ at ]filename2 = 'C:\Users\<USER>\AppData\local\Microsoft\Business Contact Manager\ MSSmallBusiness.ldf';" -- Visit team blog at http://blogs.msdn.com/bcm This posting is provided "AS IS" with no warranties, and confers no rights
"Seymour" wrote:
[Quoted Text] > I have a my bcm 2003 data base. It appears that BCM 2007 does not recognize > the (mdf,ldf). nor can I import it. BCM 2007 cannot select it not recognize > it. > > If there is an integrity problem with the my 2003 database is there a way to > fix it so that 2007 will recognize it ??? > > Seymour
|