VS2005, dataSets and stored procs (how annoying!)

  • Thread starter Thread starter Andy B
  • Start date Start date
A

Andy B

Hi...

I have a dataset with queries in them. I want to switch out the queries for
stored procs. When I tried to redefine the select query as a stored proc, I
get this error:

Cannot remove unique constraint 'Constraint1'. Remove foreign key constraint
'fk_NewsHeader_NewsArticles' first.

Any idea what the problem is and how to fix it? The other problem is when
this does work, it redefines a new tableAdaptor in the name of the stored
proc... how confusing...
 
Back
Top