Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
2 6
Impact
~8k people reached

  • 0 posts edited
  • 0 helpful flags
  • 1 vote cast
Oct
28
comment Row locking within stored procedure
Sebastian, thanks for the detailed answer. The table has a trigger so this solution didn't quite work. I was getting The target table 'tblSystem' of the DML statement cannot have any enabled triggers --if the statement contains an OUTPUT clause without INTO clause. I had to change it to DECLARE @val as table(val int); --...; OUTPUT INSERTED.LongValue into @val;
Oct
28
comment Row locking within stored procedure
@SebastianMeine it seems to be 2008, according to the Compatibility level of the backup I received
Oct
28
comment Row locking within stored procedure
@SebastianMeine good question! I am not sure what production is running, will find out, but it definitely is > 2005.
Jul
11
comment Reorganize Indexes T-SQL
Will take a look at these!