Curious: could your login naming convention be similar to your email naming convention? I see an interesting experiment brewing...

I've set this up on a server I administer and it works like a charm. The overhead is pretty close to nonexistent. The only "catch" (in my scenario...

I tried using VB6's DMO functions and it worked pretty good. I wanted a command-line object scripter and it performed OK. You might want to give that a...

You should check out a third party product by Lumigent called Log Explorer. This can roll back individual transactions. Maybe this product will influence your decision to replicate...

paulbowman:

I'm curious where you got the information that it was developed independently of Microsoft.

Cheers,

Ken

Depending on the sessions that are executing and calling, you may have to insert into a global temp table rather than a regular temp table.

Consequently, you'll want to deal with...

Brendon:

To achieve the level of security you are looking for, I think you would need to run [your software] on [your server] at [your site], and have your clients email...

This is clearly an awkward position for a SQL DBA to be in: responsible for the databases on a server that you have no control over - worse yet, you...

How about writing your own .DLL and calling a set of extended stored procedures? Any of you guys have any comments on that?

I'm guessing that your databases are named after your client names, right...?

I'll vouch for the "can't do that" answer, and maybe named instances are the answer, but in a situation...

Would a Global temp table solve the problem?

rprice: check the BOL for "Bulk-Logged Recovery"

SELECT INTO doesn't generate tlogs like an INSERT statement does.

Read up on the sp_trace_... stored procedures. I've set up something similar to monitor utilization and "bad queries".

Be -very- careful about the "string-building" you do. Your first/last name strings [should] be OK as is, but if you give enough elbow room in the length of a...

Check Q308267 in the Microsoft Knowledgebase.

If you've done anything to the database with SQLDMO, this may be causing the problem.

Cheers,

Ken