Because UDFs are specifically designed to not do that. Books Online has the details of what they can and cannot do.

There's an is_recompiled column in sys.sql_modules. Is that what you're looking for?

Not sure what details you need. You can't run procs from inside UDFs. What details can there be beyond, "can't do that"?

I'm talking about Windows accounts. Have one that's a sys_admin (full rights to everything), and use that where it's needed. Have another that has minimal rights, maybe datareader,...

Tell it to refresh the column list.

It's the most efficient way I know of for that. You might have a better option with full text indexing. I don't know enough about that to say...

You're welcome.

Nope.

Robert Domitz (1/12/2009)

---

After all the HR-bashing I have just read, I would love to see the HR viewpoint on this question. It has been my experience that they are...

Whether you go 2005 or 2008, Standard should do what you need in the situation you are describing.

Do you have a test environment where you can load up the databases...

Except for tempdb, no.

You might need to be listed as a sys_admin in SQL security. I don't remember.

Those mean that either you have the wrong password for the sa account (possible), or that the package was saved with encryption. When you save an SSIS package from...

Do you keep a journal or log of server events or anything of that sort? Do you have any sort of audit trail on that data? If no...

Steve Jones - Editor (1/12/2009)

---

Interesting you've never used it. I use this as a first glance when I get a complaint about a new server. It's a thumb-sketch to see...