Got an odd one for you today and i`m hoping you can point me in the right direction.
I have 5 servers. 1 is production the rest are dev,tst,stg and are all configured identically (supposedly). On each server there is a service connecting to the sql installation.
In sysprocesses the nt_username for the service is [machine_name$] for the production box but on all the other boxes the nt_username is SYSTEM. I need the production box to say SYSTEM as the service updates records and logs the update under [machine_name$] and users are bitching.
I've read up about the [machine_name$] but i can't make the link between that account and SYSTEM so i can get the production server to use SYSTEM .