Execute MSSQL Stored Procedure

Hello I have a problem to exec stored procedure of MSSQL use CodeIgniter. 

While i use $this->db->query("EXEC SP_NAME")->result();
also return an empty array.

 But in this case if I exec in Management Studio with this command also return data.

 Please help me if you know because its important.
 Thank You.