Thanks! It would be after June... Glad to hear the upgrade might be pretty straightforward ... since 2008 SSRS has a lot of odditys ...

2008 R2 State Pensions Shop, considering 2012 for the SSRS upgrade... any comments appreciated.

Igor,

We had TRIGGER to history issues way back and we so no need to update in the Delete stored procedure as the history trigger exists...

Thank you Igor

I do see where the delete stored procedure does an update and then a delete

so if the user deletes before they create a new entry

the...

It turns out I was looked at the wrong stored procedure

After I altered the correct stored procedure to match the table alter it worked fine.

Thanks for the help !

We use this to make sure we are in DEV

before we call a stored procedure that deletes data

use master

go

declare @DEV_sysserver_srvname varchar (20)

select @DEV_sysserver_srvname =...

Actually the stored procedure is trying to update a record that does not exist.

This query is executed within a nested transaction,

the transaction isolation level is read commiited

no lock hints are used in the selects of the stored procedure in an attempt...

If you stop the sql service Named MSSQLSERVER

it will kick everyone off SQL Server.

Then you can restart the service.

Might want to send an email first.

-- example

if @ins_error1 = 0 and ins_error2=0

     begin

             commit TRANSACTION

             print 'good commit both tables should be updated'

             select @ins_error1

             select @ins_error2

      end

else

      ...