The table Users is replicated from production to all the non-production Apples-Seucrity.dbo.Users tables. The UserID in the non-production table is created with NOT FOR REPLICATION which means that the seed...

I believe replication has bitten me once again. I haven't taken into consideration Replication Identity Management. This is what happens when the Development team wants to play with replicated tables.

Sorry Sean. Here's a briefer summary of the objects.

Apples
procedure - insertUsers
view - Users (points to Apples.dbo.Users)

Apples-Security
table - Users (contains Identity column UserID and...

Basically, I'm trying to get the target table(s) and the sql command that was executed. Not the entire sql batch like you get in the extended events but the actual...

*bump*

Thanks! The ODBC SHOULD be on the current User and is Integrated Security so I'm going to keep my fingers crossed and test it out.

Erin

We are all in a standard work environment of Windows 7 and all using Office 2010. Now that I think of it I could just build a front end myself...

Not currently. The clients have the front end on their systems and this is supposed to be as transparent as possible.

To avoid results like O'GaraD you're going to have to employ logic such as (possibly):

Any characters that occur BEORE or AFTER an invalid character are also explicitly invalid. So possibly...

Thanks, everyone. That's about what I thought the solution would be but wanted to exhaust my options and make sure I wasn't missing some great tool that was heretofore unknown.

Erin

The majority are adhoc queries and even the ones in stored procedures are vendor owned and we can't change them. That's why I was hoping for something along the lines...

That's an interesting thought and I tried your code, which executed just fine, except of course if you execute it from another context other than master at which point the...

That was an excellent question, Shaun, as I hadn't thought to look at that but the answer is that AuditUser can access and perform dml statements against both databases.

*bump*

The ultimate goal is to verify that a given username exists in the ldap before querying a registered group looking for that username. Any alternate...