What table are you querying ...

alternatively you could run  a query by right clicking on the table ,selecting open table and choosing query.If you are more comfortable with access there comes the point and click...

Do all the entries look like this or some have the slash and others do not

Configure sql server agent to automatically restart

Go to Management

Right click on sql server agent

Properties Advanced

Check auto restart sql server if it stops unexpectantly

Check auto restart sql server  agent...

You are not alone .Sometimes simply sharing opens up your mind

Worked great Thanks .

Do you have directions so I could read how those work or would you mind to explain

There is also a GUI tool  mapsid.exe to map orphaned users and you can delete the users you do not want to have access to production

Mike

Could not find your error

Tom

It appears your database is growing big time.If you are running out of space in the current server please get another one .Disk space is not the most expensive thing...

You can also stop the job in enterprise manager and the rest will follow .

Mike

New to DTS designer The execute sql task is what was needed  and itworks fine.

Great to have an opportunity to get the problem out

Mike

Thanks for the responses

I found  a date not between 1753 and 9999 (203 which sql server assumed to be 20203) and there were was violation of the primary key.

That...

Did you finally get a response for this.

This could be a hardware problem..

Mike

Do you have  a .bak file anywhere?

We you running in simple or full mode ?

Mike

Since you asked ...

Software should either be handed out to a person or installed in some hardware but not both.

This is how it has been implemented  Constraint

Asset is not null...