Lynn Pettis (11/25/2008)

---

Actually, I do have a question about the table(s) that you need to do this for, and it is very generic, how many rows of data in each...

Lynn Pettis (11/25/2008)

---

Actually, you are getting out of the fog. Now that you are getting more into the What is need to be done, rather than how it is...

Lynn Pettis (11/25/2008)

---

YSLGuru (11/25/2008)

---

To perform the following command which is using pseduo names because an NDA...

To perform the following command which is using pseduo names because an NDA disallows my listing...

I'm not looking to capture any specific data or value that occurs at shutdown but to capture the data in specifc tables just prior to shutdown.

Thanks

Speaking of Undcoumented and the very popular sp_MSForEach...., does anyone know if Micro$oft either has plans to or at least has commented about the implementation of some user allowed alternative...

Adam Haines (11/11/2008)

---

Sounds like you have a very active server. The default trace will only maintain 5 trace files at a time. I believe your issue is that you...

I have tried listing each trc file in the query and still noth before a few days back.

Thanks

Adam,

Oustanding article; gives what users really want! Interesting question though, any thoughts as to why one may have Default trace data going back only a few days even though...

Jack -

Thanks for the inf. So the video you are referencing, it can show one how to basically create your own custom server side trace to do what the...

This probably sounds like a no-brainer but I have a question about the code. I understand what it does but what I didn't know about is the trace itself....

Setting Include IF NOT EXISTS clause to False did the trick.

Thanks!

ALZDBA (11/4/2008)

---

FYI

When I design a table, it always contains a datetime created / user created column as well as a datetime altered / user alterd column.

(the altered columns maintained...

Yeah, personally I can't get used to the brackets, they just don't work as well, visually, as the single quotes, especially when you have some form of syntax highlighting. ...

ALZDBA (11/3/2008)

---

Especially because it is a 3th party product, I do not advise to add columns to tables.

To achieve the thing you want, create another logging table and populate that...