linked-server
How to pass parameters for OPENDATASOURCE
I can connect to a linked server with this: SELECT testNo, soruTuruId, soruNo, cevap , degerlendirenTcNo, degerlendirilenTcNo[详细]
2023-01-01 10:16 分类:问答Linked Server in SQL Server?
Is it possible to create database in lin开发者_JS百科ked server? If yes then how. I appreciate your help.[详细]
2022-12-29 03:08 分类:问答Accessing Active Directory Role Membership through LDAP using SQL Server 2005
I would like to get a list of Active Directory users along with the security groups they are members of using SQL Server 2005 linked servers. I have the query working to retrieve records but I\'m not[详细]
2022-12-28 06:00 分类:问答How to reference a sql server with a backslash (\) in its name?
Givens: One SQL Server is named: DevServerA Another is named: DevServerB\\2K5 Problem: From DevServerA, how can I write a query that references DevServerB\\2K5?[详细]
2022-12-25 18:02 分类:问答TRY CATCH with Linked Server in SQL Server 2005 Not Working
I am trying to catch sql error raised when I execute a stored procedure on a linked server. Both Servers are running SQL Server 2005.[详细]
2022-12-24 15:26 分类:问答Will SQL Server 2000 be able to use indexes in a view over a union of a view across linked servers
I have the following scenario: 2 DB servers (Linked to each other) DB1 has a (large) table with transaction records[详细]
2022-12-23 15:23 分类:问答How to optimize simple linked server select query?
I have a table called Table with columns: ID (int, primary key, clustered, unique index) TEXT (varchar 15)[详细]
2022-12-22 21:10 分类:问答quering remote database using sql server?
I have used sp_addlinkedserver to access the remote machines db now i am writing queries explicitly on database like,[详细]
2022-12-21 16:02 分类:问答Adding linked server - SQL Server 2005 - Changing the name later
I\'m developing a web app in a testing environment with test sql servers and databases. I\'m curre开发者_JS百科ntly adding a linked server and accessing the databases and tables in the linked server u[详细]
2022-12-18 15:06 分类:问答How to capture error message returned from linked server?
How can I capture an error message returned from a linked server? As an example, if I run the following command in SQL Server Management Studio:[详细]
2022-12-18 08:57 分类:问答