0 Replies Latest reply on Mar 24, 2015 3:13 PM by vijayb

    SQL servers are not monitoried completely

    vijayb

      I have configured around 20 servers. out of 20, 5 are either warning or up status, rest are in unknow status when I try to expand I have seen below shown errors.

       

      No valid data was received. Cannot assign a default value to a local variable. Must declare the scalar variable "@majorVersion". Incorrect syntax near the keyword 'ELSE'. Must declare the scalar variable "@recordNumPerDatabase". this is on SQL2K5

       

      no information available or not able capture