Hello from 6 years in the future! Just want to say thanks for sharing your SQL code, which solved a seemingly complicated business problem for me. I'm working with...

Perhaps, but I'm not sure that's the case. A lot of things we thought were private in the past, actually weren't private. What happened was the data was too...

Reminds me of sitting in a meeting with some of my colleagues and having to keep a straight face when it was my turn to incorporate the next phrase...

Kerberos?

Or maybe the app simply isn't passing the credentials correctly?

It's pretty amazing how this type of thing is actually an invasion of privacy, especially on the highways.

I can also tell you for sure that the "community member"s name was not Jeff Morden. 😀

Totally understood and, I never thought I'd say this, but this is for a "one-off".  I'll invest some time in a better one later.  And, I totally agree with the...

30 second search https://duckduckgo.com/?q=find+column+name+in+all+databases+sql+server led to the following:

https://sqlserverplanet.com/dba/find-column-in-all-databases

Hope it helps.

Heh... ya kinda missed my point.

p.s.  You could do a "quickie" with sys.sp_MSforeachdb .  It's not something that I'd use for production code but it works for a "one off".

https://www.kodyaz.com/articles/sql-server-exec-sp_msforeachdb-sp_msforeachtable-example-tsql-code.aspx

Thanks for the reply, Jeff...    I'll just have to do this manually then, as I don't really have the time right now to write the code...

As to my...

Have...

Your signature line is starting to look more and more like SPAM, Steve.  If I didn't know you, I'd mark your post as SPAM.

As to your question, the information you...

I did answer that.  Like I said...

...it doesn't even make sense for tables as small as just 1,000 rows

... so my answer stands.  Any size Tally table to do...

Do you have some links to the documentation that compares the old v.s. the new methods?  I'm not a SSIS user but I'd like to see what they're saying.