I have about 50 some odd MSSQL 7.0 servers distributed throughout the nation.
All of them are Target SQL Servers (TSX) to my Master Server (MSX) here in my corporate office.
The MSX server has holds the scripts that get distributed to all of my TSX servers... in theory.
Over time, most of the TSXs have become "Blocked" and will not take their new scripts from the MSX. Only about 5 or 6 are still left uncorrupted and I cannot find a common thread that makes them special.
Any ideas on how to make my TSXs take their medicine??
Thanks
All of them are Target SQL Servers (TSX) to my Master Server (MSX) here in my corporate office.
The MSX server has holds the scripts that get distributed to all of my TSX servers... in theory.
Over time, most of the TSXs have become "Blocked" and will not take their new scripts from the MSX. Only about 5 or 6 are still left uncorrupted and I cannot find a common thread that makes them special.
Any ideas on how to make my TSXs take their medicine??
Thanks