The SQL Server "linked server" feature makes it possible to execute commands, such as a SELECT statement, on a remote server.
I have a stored procedure that should be able to be executed on any table of any database on my …
sql sql-server stored-procedures linked-serverI created a Linked Server from my local Sql Server, as given in http://sqlserverplanet.com/dba/local-linked-server However when …
sql-server sql-server-2008 stored-procedures linked-serverI have a server SourceServer I am connected to which has a linked server TargetServer. How should an insert statement …
sql-server insert linked-serverIs it possible create/configure MySQL for functionality like SQL Server's Linked Server? If yes, would you please tell me …
mysql linked-serverI want to port data from one server's database to another server's database. The databases are both on a different …
sql sql-server tsql linked-server cross-serverI have a SQL Server 2012.(120.120.55.15) Today I linked MySQL server(120.120.55.30) to my SQLServer and gave it a name "MYSQL". In …
mysql sql sql-server linked-server ssms-2012I have a table called MyTable on which I have defined a trigger, like so: CREATE TRIGGER dbo.trg_Ins_…
tsql triggers sql-server-2008-r2 linked-serverI'm trying to pull in data from a remote SQL Server. I can access the remote server using SQL authentication; …
sql-server linked-serverIf I want to run this sort of query in SQL Server, how can I do the same query from …
sql sql-server linked-serverI want to be able to programmatically (in T-SQL) check if a specific linked server already exists for my current …
sql-server tsql linked-server