.net 2005 Command Builder not generating UpdateCommand for TableAdapter   

I'm having a hard time figuring out why I can't generate an Insert,
Delete or Update command for a tableadapter (attached to the
datatable).

The table is located in an SQL 2000 database.  In .net 2003, I had no
problem with the dataadapter wizard generating the command statements.

I click the "Advanced Options" button in the Command Builder.  I ensure
the "Generate Insert, Update, and Delete statements..." is checked.
I've tried checking and leaving unchecked the optimistic concurrency
and refresh the datatable boxes, but neither allows this to succeed.

In the wizard, my GenerateDBDirectMethods checkbox is grayed out, but I
assume this is only applicable for SQL 2005 databases, and not SQL
2000.

On completion of the wizard,  I get the following results (with no
errors):

Generated SELECT Statement
Generated table mappings
Generated Fill method
Generated Get method

It says nothing about generating an UPDATE, INSERT or DELETE statement,
neither for success or failure.  In browsing the properties of the
tableadapter, the "command" properties are left blank.  Since I checked
the box to generate these commands, I'd expect at least an error if
they couldn't be generated for some reason.

I've ensured that there is a clearly identifiable primary key within
the database, and the datatable is reflecting the key properly.

The build version I'm using is 8.0.50727.42

Thanks,
Marc

date: 5 Jun 2006 13:39:24 -0700   author:   Marc Michaels