sql server - The current transaction cannot be committed and cannot support operations that write to the log file. Rollback the transaction -
    i'm encountering error when running script in sql server 2008. when restore database in sql server 2012, runs , did not encounter errors.   thanks in advance!   here stored procedure:   create procedure updatedependentviews   (                                                                @tablename nvarchar(128),    @alldependents bit = 1   )                                                                                              set nocount on;      create table #dependencies     (        [counter] [int] identity(1,1) not null,        [view_name] [nvarchar](128),                               ) on [primary];      create index counter on #dependencies(counter);      /* first degree dependent views. */       insert #dependencies(view_name)          select v.[name] [view_name]          sys.sql_expression_dependencies sd          inner join sys.views v on sd.referencing_id = v.object_id          inner join sys.objects d on sd.referenced_id = d.object_id          sd.referenci...