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,...

You don't have to specify a mirror, but you can. It was the same in SQL 2005. No changes in that area.

Books Online SQL 2005:

The data-access provider, whether SQL Native...

If the trace is stopped and closed (not...

Temp tables are local to the connection that creates them, they cannot be affected by anyone else and they are...

Hmmm.....

I know there were some issues with the maintenance plans in SP2. They were fixed in a re-release of SP2, but you've got the initial release of the service pack....

Change tracking

Change Data Capture

SQL Audit