Oh, that makes much more sense! I implemented a similar strategy once when there was a complaint that an unknown person was deleting and modifing rows from outside the erp...

Table triggers will kill your performance and are generally frowned upon. If your database is small and your users are few it won't matter, but this isn't a scalable solution.

I'm...

Developers could certainly have read access to production data. If a production change needs to occur to data for whatever reason, the production change should be done by an ops...

First, if your developers have the ability to delete data from a production database, it's not a production database, it's a development database. There's no excuse for letting developers into...

SQL Server 2008 was version 10, not 9.

XP end of life was in 2014- the extended lifespan for XP was only available through a hack that makes your system look...

Singular. I teach singular and I beg people to use Singular. Not only do we not have to remember if there is or isn't an S if we just know...

http: / / DNS.STUFF.is.ONLY.HERE / thisPartIsHTTP
(spaces to prevent auto linking)

Also, it is INCREDIBLY bad advice to recommend modifying HOSTS. That's what DNS is for. Modifying HOSTS is...

> You could probably modify the hosts file to redirect to the reporting server or update your DNS server. 

Just for future people finding this thread. no, you can't...