No, nobody is resolving the conflicts manually.

Thanks very much. The problem actually was that the default directory the device was 'created' in did not exist!!

The device showed up in sysdevices so no idea what is...

Thanks for the reply but that is not the case

As an aside I did manage to get round it by changing the connection details in the Agent properties to connect with the sa user instead on Windows authentication. ...

I see your point about denying the login as a deny supersedes anything else but this doesn't explain why the MSSQLService account is okay?

Do you know of any possible problems...

SQL Agent is running under a domain user account with local admin rights on the machine. I have added it as a login with sys admin rights. I...

Thanks again!

I don't actually want to set an NT variable I want to retrieve an NT variable from within a select statement. For example I would want to retrieve...

Thanks for the reply.

Could you give an example, I'm new to the TSQL side of things.

Much appreciated

Pete

Thanks for the reply Steve.

The client wants this because if the MSSQLService has to be taken down or fails over to the other node then it will affect all databases...