Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-01-13 : 09:11:23
|
| Richmond writes "HiOK The situation first...2 linked SQL servers (srvMail and srv)srvMail has SQL email component installed and srv does not both have a database called CommonCodeDb that contains (you guest -- common UDFs)one of the common Udf's is udf_Email BUT this only works on srvMail via master.xp_sendmailHow can you use the srvMail.CommonCodeDb.udf_Email from the linked srv Server ??I hope that I was clear in my question and if not Sowwwwey... Happy new year" |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2003-01-13 : 17:48:42
|
| Perhaps with 4-part naming, or maybe you'll have to call a stored procedure on the other server that will then use its local CommonCodeDB.------------------------------------------------------The more you know, the more you know you don't know. |
 |
|
|
|
|
|
Linked Server and User Defined Functions