I suspect that's the situation that the OP is in. 🙁

Won't help here. Login triggers only fire if the login was successful, they're not going to...

Is the table in question a heap? (no clustered index)

Could someone who knows their way around firewalls please help this network admin out?

http://www.sqlservercentral.com/Forums/Topic1624301-1550-1.aspx

But you still lose the advantage of compressed pages in memory.

Yes, still only three options for what to do with the connection, but on the scope page you set what IP addresses the rule applies to.

Please, get someone who knows...

Custom rule -> Scope

They're key locks. So the two processes each have an exclusive lock on a different row of the same index. Perfectly possible.

ALTER INDEX or ALTER TABLE with the rebuild clause.

Dedupe on the data files? That's got to be a violation of the IO requirements SQL has (once written data is not...

When I said speak to the network admin, I meant the person who knows their way around networking and firewalls.

I am not a network admin, I don't know firewalls well,...

I guess you could check sysjobs and see when the last time the index rebuild job ran. Other than that, there's no easy way to track when an index was...

Speak to your network admin, denying all IPs but for a range is something all firewalls should be able to do.

Table definitions, index definitions and execution plan please.

That's something you'd configure within the firewall. Speak to your network admin or ISP's network people.

I prefer to put the COMMIT inside the try block, rather than outside where an IF is necessary

So....

BEGIN TRY

BEGIN TRANSACTION;

-- Generate a constraint violation...