>Is there any way to count records in a buffered (mode 5) view without moving the record pointer?
Check new WITH (buffering) option of Select-SQL. I'm not sure how does it work internally and it is a slow option, be aware.
If it's not broken, fix it until it is.
My Blog