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...