Suggested a MS Support call.

Let's see what happens.

Thanks All.

Andy P

Well guys, looks like I'm well and truly scuppered.

SUMMARY:

DB was detached using EXEC sp_detach_db

Primary log file deleted.

Have tried to re-attach using:

1.

EXEC sp_attach_db @dbname (including combinations of @filename2/@filename3 for primary and...

I see from the first posted message that in the States you also have companies that have no development or quality environments. I thought that was a UK phenomenon. Certainly...

Similar really, started out as VB programmer, even mobile SMS apps required good DB skills (allbeit MS Access V2). Natural project progression through MS Access to SQL-SVR. Now (in a...

I'll try that in the morning.

I was also going to try attaching to a different server (sql-svr 2000).

I have just realised that this has been posted to the wrong forum...