yes thank you very much

Thank you very much 🙂

Thank you, my problem solved by synonyms 🙂

first I tried to create synonyms inside my function which did not work

and I got the error.

but then I created the synonyms in...

Thank you Todd, but it seems that I can't use synonyms inside a function.

I'm receiving the following error:

Invalid use of side-effecting or time-dependent operator in 'CREATE SYNONYM' within a function.

thank you, but I've used this function in several stored procedures and it works well in my main server which has all the DBs. but other servers in other offices...