yes the domain name is correct, btw i have also got a static ip, i have tried changing this too

haha yes i have definitely tried rebooting my machine 🙂

I am only connected to the network via network cable, there are no issues that we know of from our domain...

thanks for your response but i have already trawled google and tried many solutions which have not worked im afraid

my login password has not expired and is set to NOT expire so i dont think it is this as i can access the sql server from a diff machine...

yes this is correct, i can access it from any other machine using the same windows authentication credentials. i can also access it through my local machine using the sa...

well i havent changed any of my passwords on my local machine or on any servers or any sql instances

Yes that is the one i am looking for, thanks for your help

Thanks for your responses; I have tried all the SELECTs you have suggested but I am still receiving records back which contain a value in the 'Pass2' column.

Any more ideas

Thanks for the reply, but all i am looking for is a document that states what does what in the script.

ok thanks for that, but what i was looking for was starting simple script e.g. GO, FROM ect and what it actually does.

Thanks