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:
Oh, and guess what?
sqlsrv_num_rows() worked for me to boot! Weird.