Well after spending all day trying to figure this out, it turns out compatibility_level was altered on the server. After changing that back to 100, it my stored procedure works...