That makes sense gail.   I saw it there in the event log several times but was focused on the login aspect.

I recently could not get into XP and had to...

Hi people.

JUst a quick note to let you know that I solved the problem by uninstalling SQL Server and re-installing it.   Have "attached" the subject database and all is sweet...

Hi Jeff, Rudy, SQLBill.

Thanks for your help.   I am still in the same situation with this.

As promised, I am posting details from the PC's ERRORLOG files as follows: -

Contents of...

OK, here it is:

Local System Account, with "Allow services to interact with desktop" ticked.

Hardware Profile = "Profile 1"

Service = "Enabled"

Lester Vincent

Sydney

That's a difficult one to answer, Gail. I have been using Windows Authentication, with my first name as User (with Administrator rights) and a blank password.

With the aid of some...

I will look again at the Event Log, Gail.    Cannot get in at present, as I'm having some trouble getting SP4.0 to install, as it is taking a long time...

There was no error message trying to Start from the Service Manager, just nothing happened, but trying to start SQL Server Agent, the error was

"Error: The dependency service or...

Hi Gail.   See details in my reply to SQLBill.

I do have a backup as at mid-December, which is close to the last time I visited the database.   (It is in...

Thank you for responding, Bill.

>Go to Services on the system. Find the MSSQLServer and SQLServerAgent service.

I went to SQL Server Service Manager, selected "SQL Server" and "SQL Server Agent"...

Thank you, Minaz.   I have printed out KB article, 328306 to look at.  It contains references to 20 other KB articles and I will look at all of these.    Quite a few...

Could not find Windows event-log, but looked in Windows System Information/Software Environment/Services.  

Found MSSQLSERVER and its State showed "Stopped";

Start Mode=Auto; Service Type=Own Process;

Path=C:\Progra~1\micros_4\mssql\binn\sqlservr.exe;

Error Control=Normal;

StartName=Local System; TagID=0

I...

Thanks Charles, Richard and Rick for your terrific help on this.

I'm on the way with it now, using a SPROC which

(a) gets a rowset of tablenames from sysobjects, (as per...

Thanks Charles.    

Your solution sounds so simple it has me worried, and I don't know why.   Maybe I'm just being ultra-careful in some unfamiliar territory.

Since my posting, I found the...

Thanks David.    I will file your great tips in a safe place.   This is a fantastic forum outcome.   Hope I can be as helpful to someone else.

Cheers,

Lester Vincent

Hi David.   AS I had to solve this somehow today, I looked again at BOL, found the format file values had to be tab-separated.     I had to correct this, and tried...