Click here to Skip to main content
15,888,984 members
Search within:


if database1 in the another server ,can i call its function in the database2?
Please Sign up or sign in to vote.
0.00/5 (No votes)
if database1 in the another server ,can i call its function in the database2?

SQL
Select Database1.dbo.GetName(Code ) as name1
From Database2.dbo.tableA
Posted
Add a Solution

1 solution

No. The connection to SQL server is server specific, and you would need a separate connection to connect to the other SQL server instance. The only exception to this is when you have a database farm, but then the database is effectively distributed across multiple physical servers, but counts as a single SQL Server instance.
 
Share this answer
 
Posted
Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month
Related Questions
Add data from server1 database1 to server2 database2
how to insert a data from database1 to database2 note they dont have the same server
How to copy one table from database1 to database2 using sql?My codes result finally lost primary key
Bulk insert from database1 to database 2
Call C# function and keep its functioning on server even close a browser
Calling function client and server side
Oci8 error: call to undefined function oci_connect()
call function in .aspx.cs from .aspx
How can get ordered by result within a function in SQL server
Use a thread and call a function

Advertise
Privacy
Cookies
Terms of Use
Last Updated 30 Jul 2011
Layout: fixed | fluid
Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web01 2.8:2024-04-02:1

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900