• noeld (10/25/2006)


    That error is because you are probably connected to a database that has compatibility level set to 8.0 (2000) instead of 9.0 (2005)

    Cheers,

    <img src='images/emotions/smile.gif' height='20' width='20' border='0' title='Smile' align='absmiddle'>

    Nope the DMV will work even its compatibility level set to 80.

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/