1
Sounds like DOMAIN\GroupName is a group and DOMAIN\user.name is a member of that group. This means that DOMAIN\user.name has access to SQL Server through that group. You have 2 options:
Create another group, let's say DOMAIN\NewGroupName and grant that group INSERT and UPDATE, then make DOMAIN\user.name a member of that group.
This is not the fastest ...
1
how to set the value of @MaxItemSeqNum to the returned result
Either
SET @MaxItemSeqNum = ( SELECT MAX([Table1].[Item_Seq_number])
FROM Table1
WHERE Batch_Id = 1
Group By Batch_Id );
or
SELECT @MaxItemSeqNum = MAX([Table1].[Item_Seq_number])
FROM Table1
...
1
There are only 2 or 3 rows in sys.dm_exec_requests with status = running
A running SQL Server request will cycle quickly (perhaps every 4ms) between running, runnable, and suspended. running means that the task is actively using a CPU core (aka a Scheduler). runnable means that it need to use a Scheduler, but it's waiting for one to be available, and ...
Only top voted, non community-wiki answers of a minimum length are eligible
