I can connect to a linked server with this: SELECT testNo, soruTuruId, soruNo, cevap , degerlendirenTcNo, degerlendirilenTcNo
Is it possible to create database in lin开发者_JS百科ked server? If yes then how. I appreciate your help.
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
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?
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.
I have the following scenario: 2 DB servers (Linked to each other) DB1 has a (large) table with transaction records
I have a table called Table with columns: ID (int, primary key, clustered, unique index) TEXT (varchar 15)
I have used sp_addlinkedserver to access the remote machines db now i am writing queries explicitly on database like,
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
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:
加载中,请稍侯......