No idea....

In general, triggers should not start jobs, send email, launch applications or anything of the sort. A trigger should be doing small data verifications or changes, nothing more.

😀

As I mentioned over at SQLTeam, you may want to give CSS a shout. If no one's answering it's most likely because they don't know.

Ok, so you need the users, with their database and server roles and with the permissions that they have directly on database objects.

One database or all?

So you want to display users who are members of database and/or server roles? With the roles they are members of?

You're not interested in permissions that users may have directly...

Or, preferably, since the...

I think I've seen just about everything. From that to the "Who are you to...

Use either DBCC INPUTBUFFER or fn_get_sql in conjunction with sysprocesses. There's no simple, easy way of getting the commands on SQL 2000 though.

Thanks. I'm more asking out of curiosity. I don't tend to write CLR.

You can also read this post. I don't know if there's more info than in BoL though.

http://sqlinthewild.co.za/index.php/2007/12/30/execution-plan-operations-joins/

The links after each section go to the blog of one of the SQL...

You can query the sysprocesses system table.

As with many of the system tables, it's well documented in Books Online, including what each of the columns mean.

Jeff Moden (11/30/2008)

---

I still want to know what the CLR(s) the op wants to write do. We all know that too many people give up on T-SQL way...

Just to be clear, those are three new features in SQL 2008 that can remove the need for triggers for auditing, depending what you want...

Per Books Online:

sp_trace_setstatus [ @traceid = ] trace_id , [ @status = ] status

Arguments

[ @traceid = ] trace_id

Is the ID of the trace to be modified. trace_id is int,...