Thanks for the suggestion about the inline function. I am a real novice at writing functions and this quickly solved a problem that I was struggling with.

I need something that is sort of the opposite of this script. This script shows me all of the objects that the database role can access. I need...

Thanks, Michael. I have needed something like that for a long time and had no clue how to write it. Nice work. I really appreciate it.:-)

Once again SQLServerCentral has bailed me out quickly. Thanks for your post. I had not thought of writing my own function. I use them occasionally, but not...

Thanks much for the suggestion. I tried it and it works perfectly. It will save me a great deal of time. Still not nearly as good as...

I just recently upgraded to SQL Server 2005 as a database for a major MS-Access project.  I have about 150 views.  I had a macro that refreshed all of the...