Maybe I don't understand your response, but if I need at least a NULL for @param2, isn't optional. I'm right?

I have:

create function dbo.MyFn(@param1 varchar(10), @param2 varchar(10) = 'No input') as
...

And...

Thanks, I'll consider it.

Now I have another problem with this UDF. I'm trying to put an optional parameter inside this UDF, but doesn't seem to be accepted.

I've tryed a similar...

Arrrghh.

That's ugly. I need the result table to perform joins on local tables.

I think I will duplicate the function on local DB using remote tables. Seems to be more elegant.

Thanks...

I thought it was easier.

I think I would grant public role in DB "B", I prefer keep it simple.

Thanks

Hmmm, I don't understand.

Execution Plan shows:

Estimated Subtree Cost = 3.3 and estimated row count = 10000 for OpenQuery (performs a Remote Scan).

Estimated Subtree Cost = 0.0388 and estimated row count...

I know, but correct me if I'm wrong...

I've readed that server.db.user.object usage get ALL data to server, and the local server perform the filter/join/etc.

And using OpenQuery the filtering/join/etc is made...

Well, I can say you that I have no problem executing it.

What I can see in your post is that you entered: "@recipient = 'me@mycompany.com'" and must be "@recipients =...