140 reputation
16
bio website jstawski.com
location North Miami, FL
age 33
visits member for 3 years, 9 months
seen Aug 1 at 15:39

I am a Microsoft Certified Application Developer (MCAD) and Microsoft Most Valuable Professional (MVP) with over 10 years of experience building and architecting .NET applications and over 12 years of professional experience using Microsoft development technologies such as ASP, Visual Basic, and SQL Server.


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!