linked-server

相关标签：javascript jquery android 多少钱 iPhone

Insert Data From One Server To Another?

If I want to run this sort of query in SQL Server, how can I do the same query from one server I am connected to to another?[详细]

2023-01-08 12:14 分类：问答
Selecting a column with period in the column name SQL Server

I am linked to a Proficy Historian that allows periods in the column names.Because the data is stored in a non DBMS format I can not use openquery to get the data because there is no set schema to the[详细]

2023-01-07 19:10 分类：问答
SQL Server - what permission need to open for view a table schema in a linked server

After creating a linked server on SSMS 2008, how should I see linked server table schema? Should I change any permission on remote SQL Server? Also, what commands can check those permissions for all a[详细]

2023-01-07 12:01 分类：问答
Error connecting to linked server after recompile

I have a ASP.NET MVC website in IIS 7 running against a SQL Server 2008 R2 database, in which I have a linked server set up.The linked server is set up so that a SQL account from my database is linked[详细]

2023-01-07 04:13 分类：问答
Update linked SQL server with parameters

I have two linked SQL servers and i am trying to issue an update on the other server but am getting an error \"Statement(s) could not be prepared.\", followed by \"Must declare the scalar variable \"@[详细]

2023-01-05 09:59 分类：问答
openquery issue in SQL Server

I am using SQL Server 2008 (let us call this source database server in this question discussion), and in SSMS, I 开发者_运维技巧have created a linked server to another SQL Server 2008 database (let us[详细]

2023-01-04 07:02 分类：问答
Problems with sp_addlinkedserver in SQL Server 2000

I\'m having a bit of a problem with moving specific data from one server running SQL Server 2000 (A) and another running SQL Server 2008 (B). I\'m writing a script according to customer specifications[详细]

2023-01-04 00:40 分类：问答
Data-Tier Projects and Linked Servers

I\'m trying to use a Data-Tier application involving a linked server and running into an odd problem.[详细]

2023-01-03 04:14 分类：问答
How to Insert into remote table using Linked server withint Transaction?

My Linked server is setup correctly , I am able to perform below query. INSERT INTO [RemoteServer].[Table][详细]

2023-01-03 03:22 分类：问答
Linked servers SQLNCLI problem. "No transaction is active"

Im trying to execute a stored procedure and simply insert its results in a temporary table, and I\'m getting the following message:[详细]

2023-01-02 00:41 分类：问答