Use SQLServerCentral

go

Update Politicalviewpoint

Set President="Ronald Reagan',

    Opinion='Good'

where opinion='appropriate'

Server: Msg 208, Level 16, State 1, Line 1

Invalid object name 'Politicalviewpoint'

Hi all,

Got a further question in relation to this one.  It's been suggested that I could use @@dbts  to return the final timestamp.  e.g change the final error block to:

       ...

Hi all,

Thanks for that. I wrote the below to identify my problem rows. When I was happy I was going to run the update statement thats currently commented...