From Mircrosoft Docs : "

When SET XACT_ABORT is ON, if a Transact-SQL statement raises a run-time error, the entire transaction is terminated and rolled back.

When SET XACT_ABORT is OFF, in...

My one thought here is that a call to a stored procedure may not roll back within a transaction, whereas if you do ,say,  just inserts to multiple tables within...

And what was the result? What exact message do you get?

How do you absolutely know the users do not already have permission?

OR , Is there another permission setting denying this...

Please add sample data along with DDL/DML statements to set up the tables we need to be able to see what you are seeing on your side.

Without knowing more you...

AS Jeff emphasied in his post, look at your indexes on both of your tables (even the temp table). It is worth re-emphasising.

I would also look into how the table...

You can do just

GRANT EXECUTE TO [Domain\ADGroup]

But you may not really want to do that.

AS far as SQL Server is concerned, I am reminded I just engaged on a forum question about certificates. This of course to help to encrypt the data in your...

Thank you Steve for the good thoughts.

The job interview I think candidates forget is a double interview. You as a candidate are interviewing the company as well and gauging its...

Not sure at what step you are at

What do you see when you run

select * from master.sys.certificates

Yes, attempting to approach this the wrong way will potentially hose your server for days, and rebooting a giant transaction half-way will only make things worse. I am confronted...

• This reply was modified 3 years, 7 months ago by MMartin1.

I've worked on several applications which ride on the external data being received as a flat file every day on an SFTP. The processing time was going beyond...

p.s.  We did do something great on this thread... although it's gotten a bit confrontational, it IS bringing a lot of things to light that people might not have...

I was pointing that out to the OP... Maybe read a little of The Data Warehouse Toolkit to learn how to build star schemas might be in order. I...

Yes, agree that it would benefit in the read loads. But we should also consider the overhead of CI on write operations. So if the database is...

I think writing summary queries in T-SQL is the wrong way to go if you're consuming the data in PowerBI. It's fine to create views using T-SQL to populate...