c# – 自SQL 2008升级以来,SqlDataReader.HasRows返回false

我解决了问题是,即使数据集不为空,对SqlDataReader.HasRows的调用也返回false并且删除检查允许循环通过reader.Read()来访问预期的数据.

_connectionString = WebConfigurationManager.ConnectionStrings["SQLServer"].ConnectionString;
    SqlConnection connection = new SqlConnection(_connectionString);
    SqlCommand command = new SqlCommand(searchtype,connection);
    SqlParameter _parSeachTerm = new SqlParameter("@searchterm",SqlDbType.VarChar,255);
    _parSeachTerm.Value = searchterm;
    command.Parameters.Add(_parSeachTerm);
    command.CommandType = CommandType.StoredProcedure;
    try
    {
        connection.Open();
        SqlDataReader reader = command.ExecuteReader();
        if (reader.HasRows) //this always returns false!?
        {
            while (reader.Read())
            {...

有谁知道发生了什么事？ HasRows返回正确值的其他页面上有类似的代码块.

编辑 – 只是为了澄清,存储过程会返回我已经确认的结果,因为如果我删除HasRows检查,循环运行正常.仅将连接字符串中的SQL服务器名称更改为在SQL 2000上运行的相同数据库会使问题消失.我已经检查过NOCOUNT是关闭的,那么还有什么可以让HasRows在不是这样的情况下返回false？

EDIT2-这是SP

CREATE PROCEDURE StaffEnquirySurnameSearch

@searchterm varchar(255)

AS

SELECT  AD.Name,AD.Company,AD.telephoneNumber,AD.manager,CVS.Position,CVS.CompanyArea,CVS.Location,CVS.Title,AD.guid AS guid,AD.firstname,AD.surname
FROM ADCVS AD
LEFT OUTER JOIN CVS ON
AD.Guid=CVS.Guid 
WHERE AD.SurName LIKE @searchterm
ORDER BY AD.Surname,AD.Firstname
GO

提前谢谢了.