Yes, but it requires dynamic SQL which means you're at risk of SQL Injection attacks.

SQL doesn't keep that kind of historical data. To find that out (especially the who accesses it), you'll need to run traces for long periods of time.

Then it's probably not the query. If it's inserting 1 row and the insert is 100% of the cost, there isn't going to be...

Because something, somewhere in the package requires permissions which the SQL Agent Service account...

Hang on, I'm confused.

You said you don't want him to see the definitions of the objects.

Then you said that you tried denying view definition and it worked, the login was...

Not at all, a clustered index doesn't have to be unique

(seriously...

He's got to query the DB but isn't allowed to know the table names? How does that work? How does someone write queries without knowing table and column names?

What leads you to believe that?

Eirikur Eiriksson (9/7/2014)

---

Quick thought, it's likely that this is not a problem of any sort, if the action is only an insert then the cost percentage is always going to...

Nothing you've said has suggested that lock escalation is the cause, and there's no deadlock graph or query details provided, so no way anyone can say anything useful

As far as I'm aware, there are no changes to the lock escalation mechanisms in SQL 2014.

Open up Books Online (the SQL help file) and search for DENY

If the problem reoccurs, call Microsoft customer support and open a case. A rollback shouldn't fail and take the DB offline, for any reason.

Personally.... My father's an engineer (mechanical). I know what goes into studying to be an accredited engineer. I will never use the title Engineer for myself (I'm not one)

When, several...

Just bear in mind that the counter in question is not the number of mid-index page splits (which are the expensive ones that cause fragmentation)