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

Michael Earl (11/3/2008)

---

Just giving the column a DEFAULT will not help you. Your third party application is not aware of the column, so it is not going to include...

Matt,

Thanks for the followup/info as well as the URL on deprecated items.

If I follow correctly you say that the method of

TABLE.ColumnName AS 'MyAlias'

for providing a column...