Article ID: 174855
Article Last Modified on 10/3/2003
APPLIES TO
- Microsoft SQL Server 6.5 Standard Edition
This article was previously published under Q174855
SYMPTOMS
BUG #: 17241 (6.5)
Selecting from a table with 224 or more columns fails with the following error message if a user has column-level permission:
WORKAROUND
If the user is given SELECT permission on all columns, then he or she can select from individual columns.
STATUS
Microsoft has confirmed this to be a problem in SQL Server version 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.
Keywords: kbbug kbusage KB174855