database attaching

we have a pllication that uses MSDE databases, we send out updates we detach
copy new file in and reattach.
Problem: I have a couple of machine the MSDE server want allow the mdb files
to attach. WE remove the current log files after the detatch. Almost like the
machine does't know the SQL server exists anymore.
Hi,
Are you facing the issue to attach the database only with MDF? If yes then
try to attach the database using below command:-
EXEC sp_attach_single_file_db @.dbname = 'DBNAME', @.physname =
'd:\MSSQL\Data\DBNAME.mdf'
Thanks
Hari
SQL Server MVP
"msatullo" <msatullo@.discussions.microsoft.com> wrote in message
news:FA3791F6-F23A-44FE-B6BD-95753C70628C@.microsoft.com...
> we have a pllication that uses MSDE databases, we send out updates we
> detach
> copy new file in and reattach.
> Problem: I have a couple of machine the MSDE server want allow the mdb
> files
> to attach. WE remove the current log files after the detatch. Almost like
> the
> machine does't know the SQL server exists anymore.
|||The databases are attached when the program starts
I get the following errors when the program tries to attach
-2147024769 automation error- the specified proceedure not found
"Hari Prasad" wrote:

> Hi,
> Are you facing the issue to attach the database only with MDF? If yes then
> try to attach the database using below command:-
> EXEC sp_attach_single_file_db @.dbname = 'DBNAME', @.physname =
> 'd:\MSSQL\Data\DBNAME.mdf'
> Thanks
> Hari
> SQL Server MVP
> "msatullo" <msatullo@.discussions.microsoft.com> wrote in message
> news:FA3791F6-F23A-44FE-B6BD-95753C70628C@.microsoft.com...
>
>