ADO.Net 2.0 + SQL Server 2005 + SqlDataTable.Load = ReadOnlyDataColumns

[Nergock@gmail.com]

Has anyone run into this discrepancy with SQL Server 2005 and the
SqlDataTable Load method?

In SQL Server 2000, when I create a table using the SqlDataTable.Lo ad
method passing it a SqlDataReader, I get a DataTable with DataColumns
with ReadOnly property equal to False. However, the same method in
SQL Server 2005 will
return a DataTable with DataColumns with ReadOnly property equal to
True. Changing the code
to use SqlDataAdapter. Fill method fixes the issue but does anyone
know
the reason for this discrepancy between SQL Server 2000 and SQL
Server
2005?


SqlDataTable.Lo ad(SqlDataReade r) returns readonly columns in SQL
Server 2000.
SqlDataAdapter. Fill(SqlDataTab le) does not return readonly columns in
SQL Server 2005.


(The SqlDataReader was created using the SqlCommand.Exec uteDataReader
method.)


Thanks.