linked-server
Performance implications for using OPENQUERY in a view [closed]
Closed. This question is off-topic. It is not currently accepting answers. Want to improv开发者_开发技巧e this question? Update the question so it's on-topic for Stack Overflow.[详细]
2023-04-12 14:12 分类:问答How do you get the ouput from an EXEC statement into a variable (calling procedure on mysql linked server)?
I am able to call a procedure on a linked server (MySQL) from Sql2k5. The procedure returns a single row, single column:[详细]
2023-04-07 23:17 分类:问答Is there a way to prevent SQL Server from Validating the SQL in a stored procedure during CREATE / ALTER
One aspect of our system requires our SQL Server instance to talk to a MySQL Server via a linked Server Connection.[详细]
2023-04-07 11:22 分类:问答Expose Microsoft Access database over SQL Server using linked server
We have one .exe application that uses one .mdb Microsoft Access database. I need to access data inside access file over Microsoft SQL Server. We have SQL Server 2008 R2 Enterprise that has linked se[详细]
2023-04-06 07:04 分类:问答Trigger Error on MSSQL with an OPENQUERY to Linked Server with MYSQL
i got the following issue: i got a server running开发者_运维问答 Win Server 2000 / MSSQL Server 20000 (Don`t ask why), i have in the MSSQL server a linked server who has MySQL 5.1.[详细]
2023-04-03 21:31 分类:问答SQL Server inserts within a trigger to a linked MySQL server not working
I\'m trying to test inserts to a linked MySQL server using triggers, but am having a few problems. System-[详细]
2023-04-01 19:13 分类:问答SQL Server 2008 Linked Server and CONTEXT_INFO
I\'m trying to use the SQL Server 2008 Change Tracking feature. Once the feature is enabled, you can make use of the CHANGETABLE(... function to query the change tracking history that is kept internal[详细]
2023-04-01 16:37 分类:问答Entity Framework 4.1 code first with a DB2 Linked Server in SQL
I would like to use Entity Framework 4.1 Code-First to build connections to my databases whether they are on our SQL server or DB2.I feel like I\'m almost there, but just can\'t get it to work.[详细]
2023-03-31 19:50 分类:问答Cannot connect to SQL Azure using a Linked Server
I\'ve been following this article here: http://blogs.msdn.com/b/sqlcat/archive/2011/03/08/linked-servers-to-sql-azure.aspx[详细]
2023-03-30 22:36 分类:问答Linked connection between MS SQL SERVER and Sybase ,Unicode problem
I added linked server on MS SQL SERVER 2008 with Sybase ASE 12.5 databases, everything works fine, but i\'ve got problem with开发者_JAVA百科 unicode strings.[详细]
2023-03-30 10:52 分类:问答