Microsoft KB Archive/139550

{|
 * width="100%"|

BUG: LOAD HEADERONLY Does Not Return @@rowcount

 * }

Q139550

-

The information in this article applies to:


 * Microsoft SQL Server version 6.0

-

SYMPTOMS
The @@rowcount global variable returns zero (0) for rows affected by the LOAD HEADERONLY command regardless of how many rows are returned.

WORKAROUND
The application can count the rows as they are returned.

STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.0. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: sql6 load headeronly

Keywords : kbprogramming

Issue type :

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600