I have a table with the following definition.

CREATE TABLE [dbo].[table1](
[ID] [uniqueidentifier] NOT NULL CONSTRAINT [DF_con1_ID] DEFAULT (newid()),
[col1] [varchar](255) NOT NULL,
[col2] [int] NOT NULL,
[col3] [varchar](255) NOT NULL,
CONSTRAINT [PK_table1] PRIMARY KEY CLUSTERED
(
[ID] ASC
)

When querying the table in the new query window with the follinging query the ID column is not displayed. All other columns are displayed.

select * from table1


When I specifiy the specific column I receive an error.

select id from table1

Offending URL: http://xxxxxxxxx/swa2005/tools/query.aspx

Source: System.Web

Message: DataGrid with id '' could not automatically generate any columns from the selected data source.

Stack trace: at System.Web.UI.WebControls.DataGrid.CreateAutoGeneratedColumns(PagedDataSource dataSource)
at System.Web.UI.WebControls.DataGrid.CreateColumnSet(PagedDataSource dataSource, Boolean useDataSource)
at System.Web.UI.WebControls.DataGrid.CreateControlHierarchy(Boolean useDataSource)
at System.Web.UI.WebControls.BaseDataList.OnDataBinding(EventArgs e)
at System.Web.UI.WebControls.BaseDataList.DataBind()
at mla_gui.NewQuery.btnSubmit_Click(Object sender, EventArgs e)
at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Target site: System.Collections.ArrayList CreateAutoGeneratedColumns(System.Web.UI.WebControls.PagedDataSource)



Am I correct in coming to the conclusion that MyLittleAdmin query tool cannot select data from a column with a uniqueidentifier datatype?
Or do I have something configured incorrectly.

Thanks.