Are you getting the following error in PHP from the PHP SQLSRV driver?
Executing SQL directly; no cursor
This apparently is just a warning, so before you connect to your server, issue this command:
sqlsrv_configure("WarningsReturnAsErrors", 0);
Oh, and guess what? sqlsrv_num_rows() worked for me to boot! Weird.