The bit in the stored proc that's complaning folks is the query to retrieve the columns for the table minus the primary key.

@natedogg

What do you get if you execute the following (changing the where clause to your schema name, table name, and primary key?):

select COLUMN_NAME

from INFORMATION_SCHEMA.COLUMNS

where TABLE_SCHEMA = 'YOUR_SCHEMA_NAME'

and TABLE_NAME = 'YOUR_TABLE_NAME

and COLUMN_NAME <> 'YOUR_PK_COLUMN_NAME'

order by ORDINAL_POSITION

This is an error I didn't expect and surely would only happen if you created a table with just one identity pk column in. Is this the case? If so just add another column to the table and try again!

Cheers, James