What if you're having to locally manage the server and need to look something up in MSDN (for example)?

It's a proc SQL Agent uses to refresh the jobs cache. So, it matters.

Not sure why you'd have a user-created version, unless some DBA built a custom version of...

Don't use three-part-names for the columns. SQL 2005 doesn't support that. Use the table and column name only.

They do have uses. Few and far between, but valid uses.

The usual reason to tell people to "just don't use them", is an overreaction to overuse.

sjsubscribe (7/29/2009)

---

You must try...

Looks to me like he got the point.

Take a look at "Common Table Expression" in Books Online (or MSDN). There's a section on recursive CTEs, and it has a solution for what you're looking for here....

Yes.

Jan Van der Eecken (7/29/2009)

---

Lynn Pettis (7/28/2009)

---

Might be E3L (or ETL, but then that might be cofused as something else), English as 3rd Language; as opposed to ESL, English as...

Jack Corbett (7/28/2009)

---

Dave, nothing scheduled until September now. If I'd have known a couple weeks ago we could have maybe gotten something done in August. Our group meets...

A delay in the trigger won't do what you need. It'll just hold the transaction up and probably cause the Java to time out.

Better to have the audit process...

You could set the recursion level as an input parameter that the function passes to itself. You could set maxrecursion (see Books Online for details), but it should stop...

While the trigger is waiting, the transaction is incomplete, and locks will be held in the table. In almost every situation I can think of, this would be a...

The way I buy a chair is by going to a store that sells them, and sitting for a few minutes in every one of them that looks even vaguely...

If you query a list of the files, it would be very easy to not use the last one in the list. That's why I suggested that.