Just Can't Get Enough

lethargic

Gym

Check the default trace if it wasn't disabled, but if they did it as SA, all you will get is SA did it from X computer, but the trace may...

Extended events would be a good place to start.

In fact today's QotD is in relation to XE and login tracking

GilaMonster (11/23/2015)

---

I wouldn't bother. If a temp table is created in a procedure, it's automatically dropped when the procedure ends, so there's no chance of getting errors if the procedure...

I always drop it explicitly at the top of the script using an if exists, when its no longer needed or at the end of the script.

That way if the...

Depot

Improvement

curiosity

Range

Don't have to be using the SA account could have sysadmin rights against their login.

Plus plenty of info on the web on disabling DDL triggers, so if they really wanted...

https://technet.microsoft.com/en-us/library/bb677622(v=sql.110).aspx

https://technet.microsoft.com/en-us/library/bb677622(v=sql.120).aspx

Looks ok to me, not a case of missing [] around msRTCSIP-PrimaryUserAddress in the OPENQUERY is it?

You could but as the people have sysadmin rights they could just disable the trigger then remove the object.

As Gail stated, you can't stop people with sysadmin doing anything, you...