I am using Avast (free edition).

Just a quick update that might prove useful to anyone facing this problem in future and other suggested cures haven't worked.

The actions I took above have worked, autostart has not...

Success!!

For today at least sql server was running smoothly and all my jobs have run as I logged on this am. I will report again in one week to ensure...

Thanks for the reply, I have checked the event viewer and cannot find any errors around the same time that would indicate a problem but chekcing the error lead me...

Blimey! That looks impressive.

I have copied the code and will have a play around as I really do need to get on top of T-SQL instead of writing apps all...

Many thanks for the reply. Your code gave me the inspiration I needed to fix the data.

I resorted to creating a vb app as there was actually more bad data...

Brilliant:D

Many thanks John & md, that works great and will save me a lot of time. Having examples like this is great for learning SQl for me.

Have a great day...

Many thanks for such a prompt reply.

This is where I start and feel really :blush: thick. I tried the above code and it works great, I am having trouble adapting...