Thanks, I was wondering about the option of reseeding and I think that is my best solution at this point.  Very good info all around!

Will do and thank you very much!

oooohhh - I think I may have even known that at one time.  Thank you.  I'm sure I'm just deleting.

Now I think there can be some user rights issues when...

You guys know too much.  Thx for all the ideas.

End solution for me was:  Use the trigger idea and move the db list table (that has the trigger) to the...

Well ... that almost got me there, but unfortunately the database that the 'databases' table resides on is different from where I want the function to reside. And I guess...

Noted - thanks!

Thanks for everyone's input.  It has really helped me confirm and understand the issue better.  stax68, yr solution is intriguing!  I would have never thought of that but it seems...

That's great.  Thanks!

That's great!  Can that be used to return 2 values?  If so, how's the syntax for that?

DECLARE @x INT

DECLARE @y INT

DECLARE @strSQL VARCHAR (2000)

DECLARE @dbname VARCHAR (50)

SET...