mssql_num_rows returns -1

[iamzoli]

having the next simple code
$result = mssql_query($sql);
echo mssql_num_rows($result); // -1 always
while($row = mssql_fetch_assoc($result)) {
//actual data 3 rows
}