Duplicate post please post answers here: http://www.sqlservercentral.com/Forums/Topic671411-146-1.aspx

Do you mean a server-side trace or enabling trace flag 1222?

Either one will add some load to the server. Using a server-side trace will allow you to gather more...

I want to make sure I understand your requirements.

1. You want to log all actions done by any user to any table in a SQL Server database.

2. You...

Were they encrypted in the database or in the application?

I don't think your issue is with SCOPE_IDENTITY(). I'm more inclined to think that you have an issue with the your first ELSE.

Can you post the DDL for the...

Can you post some data structures and sample data that would allow us to experiment with the data?

What are the data types and sizes involved? Are any varchar or...

Pam,

Are you looking for free events? Would you pay for training? Would regular user group meetings suffice?

You are coming to the area just after the Orlando .NET Code...

Can you share an example of your query, actual output, and desired output? I believe you would need to adjust your query to output a row for any months...

Thanks now I can't get...

GilaMonster (3/8/2009)

---

I've seen it, long, long ago. Can't...

Grant Fritchey (3/7/2009)

---

I do like the idea of a reviewing section.... hmmmm... actually that might work over at PASS too. Can I steal the idea? Uh, I meant, borrow, with...

David Reed (3/6/2009)

---

Jack Corbett (3/6/2009)

---

As far as my wish list, I'd like to have at least one major conference (PASS Summit, SQLConnections, etc...) trip at least every other year and...

As far as my wish list, I'd like to have at least one major conference (PASS Summit, SQLConnections, etc...) trip at least every other year and a training budget (I...

Is your source SQL Server?

If it is then you should not have any duplicates in that query as you are returning DISTINCT rows from each part of the UNION operation...

jason dodd (3/6/2009)

---

Is there a way to limit the number of trace files produced in a server side trace using the rollover option? I'd like to have a server...