Hi JS,

Well, I'm afraid I couldn't wait and stopped it. I ran the steps as you wrote me before and now looks like running like a charm again.

Thank you very...

Hi jsheldon,

Yup, my Log is huge, 40GB.

I'm running the EMERGENCY MODE, so I can afterwards run the DBCC CHECKDB. When I tried to run the DBCC cmd, an error message...

Hello JTS,

Thank you very much for your response,

Well, I'm in the middle of another procedure now, just to see If I can save any of my transactions.

I'm running these statements...

Thank you, for your response and time Markus.

Kind Regards,

Kostas

Hi,

First of all, you need to have administrative rights in every computer so you can search for files (Access files: *.mdb, *.mdw, *.mda, *.mde, *.adp, *.ade). Then, you could use...

Hello Bill,

I mean that every time you install a named instance (MSDE) a letter is erased from the end of path contained in SQLPath.

for example

one install -> SQLPath becomes "C:\Program...

There is a problem for sure gentlemen. If you install a named instance in the same computer (after you have installed the SP4 for your default server) it corrupts the SQLpath registry...

declare @MustCreateFile as bit

declare @OpenForWriting as tinyint

Set @OpenForWriting = 2

Set @MustCreateFile = 1

EXEC @fsof = sp_OAmethod @fso, 'openTextFile', @fso_return out, @strfilepathname, @OpenForWriting, @MustCreateFile

exec master..xp_fixeddrives

exec sp_helpdb 'Optional your DB name'

exec sp_helpfile 'Optional your DB file name'

Please refer to books online and check DBCC statements too!