They come from all over. No culture or country has a monopoly on lazy, ignorant, incompetent workers.

I mean the staging table, varchar(max). Not just a varchar

I agree with Jason. No reason to shrink if you're going to need the space the next week.

Don't know enough about that product, but there definitely could be some better security controls and auditing improvements in SQL Server.

SSIS will work, though it's more programming.

Are you using varchar(max) as the table field type?

I'd agree with Grant. No reason for this much memory to be used. Even if it's taken and then not released, it's an issue.

Love to hear more if you do...

I haven't heard any complaints, but I'm not sure how widely these are installed. I would read through the CUs and see if you are affected by something. Note that...

We gave the SQLSaturday event and infrastructure to PASS. I'm sure they'll announce it at some point today or tomorrow.

http://www.sqlservercentral.com/blogs/steve_jones/archive/2010/02/02/sqlsaturday-bequeathed-to-pass.aspx

We are hoping PASS will continue to grow this into even...

Gsil,

You get double points for helping that individual.

You need to decide what you want to capture. Then create a table store the info. (user, time, table, etc.)

Here are a couple examples on building a trigger:

http://www.sqlservercentral.com/articles/Administration/auditingyoursqlserverpart1/917/

http://www.sqlservercentral.com/articles/Triggers/triggersforauditing/2143/

http://www.sqlservercentral.com/articles/Triggers/auditingtriggers/579/

Also, a ref: Setting Up Windows Service Accounts.

Ultimately, no, there is no way to prevent a domain admin from accessing SQL Server. If the client owns the physical box, then they can get to everything. Not sure...

LOL, I was working at the nuclear station, about 40 miles from my house. Was a good opportunity as a grad student, so I did it. Loved it.

Got promoted, offer...

You would have to scan the trace information for deletes. You could use a trigger to capture delete info and drop it in another table.

I used to drive 110 miles each way for a job. Did that for about 6 months.