I had this same problem when selecting 'Return all rows' in Enterprise Manager SQL Server 2000.

I fixed it by unregistering and registering the 'msdasql.dll' file.