If you know that TABLE_NAME is fixed across any given FIELD_NAME, you can simplfy Joel's query like so:

SELECT FIELD_NAME, MIN(TABLE_NAME)

FROM yourTable

GROUP BY FIELD_NAME

HAVING COUNT(*) >...

Explicitly use the actual name of your server.

curbina (4/9/2008)

---

Question for rbarryyoung: if you recompile everything, how can you insure that the children are recompiled before the parents. If the parents are recompiled first, say, because they are...

Apparently, I've been doing my job at home and throughout my personal life for decades...

Yep, that's it.

Not a feature as far as I know, the button works on all of my Sql2005 boxes.

The only other thing that I can think of is a permissions issue, either...

Jeff Moden (4/7/2008)

---

What kind of bugs,...

Does the output file exist yet? My recollection is that on 2005 (unlike 2000) the button will be disabled (dimmed) if the file has not been created yet.

Yeah, that's the conclusion that I came to also. I probably will load all the records into XML in the trigger and then cursor them out in an intermediate...

No, that's an rk07. Rk07's were not see-thru as far as I can recall. Maybe something from the RM or...

You're welcome.

mark (4/8/2008)

---

I must be missing something then because in SQL 2000 the line after the error gets processed hence the @@error can be captured and acted on , yet in...

This is the supported way to address it. It is also, by far, the safest, most reliable and fastest way to address it, particularily before Sql2005 (which gives us...

What I have done in the past with similar situations is to right my working queries against a set of local Views with the same names as the tables in...

That's how I...