|
How can I drop a table on a Linked Server ?
|
Total Hit (2685) |
Assume that you have to execute the command DROP TABLE tableName on a linked server. The typical syntax that someone will try is:
DROP TABLE serverName.master.dbo.TableName
This for some reason fails ... If you were wondering why this happens then the answer is simple. The context of the user
....Read More |
Rating
|
|
|
|
How to Fix Inconsistent Metadata Errors (SQL Server 7.0)
|
Total Hit (3420) |
Why does changing a table on a SQL Server 7.0 server cause "OLE DB provider 'SQLOLEDB' supplied inconsistent metadata. An extra column was supplied during execution that was not found at compile time." to occur when query the table from a SQL Server 2000 server via link to other.
BASIC UNDERSTAND
....Read More |
Rating
|
|
|
How to perform update on multiple tables of linked server.
|
Total Hit (2512) |
This code demonstrates
1) How to write update trigger which checks modification for a specified field (e.g. here DistrictId)
2) How to handle Errors during update
3) How to update data on linked server.
4) How to do update which requires joining tables
5) How to use XACT_ABORT option to handle
....Read More |
Rating
|
|
|
Linked Severs on MS SQL Part 4, Oracle
|
Total Hit (2368) |
In previous articles, we created Linked Servers to Excel, Access and MS SQL. Several stored procedures were introduced for creating links, and the security profiles that accompany them. For this article, sp_AddLinkedServer and sp_AddLinkedSrvLogin should be familiar. Several different access methods
....Read More |
Rating
|
|
|
How to add/configure a new Linked server using T-SQL
|
Total Hit (8558) |
Here is the T-SQL script to add linked server using sp_addlinkedserver SP. Once you add linked server you can add login using sp_addlinkedsrvlogin. By default current login is mapped with linked server means remote machine must have exact same login with same password in order to get access to the l
....Read More |
Rating
|
|
|
|
Linked Severs on MS SQL Part 3
|
Total Hit (1039) |
In Parts 1 and 2, we introduced the Linked Server. Starting with what a Linked Server is, the benefits to using them, as well as when to avoid them. The Distributed Transaction Coordinator, DTC, was touched on. In addition, our first examples were to create links to an Excel spreadsheet, during whic
....Read More |
Rating
|
|
|
|
Linked Servers on MS SQL Part 2
|
Total Hit (999) |
In Part 1 of this series, we reviewed the purpose and reasons for using linked servers, as well as when not to use them. The first linked server created was to an Excel sheet containing data from the Authors table of the SQL Pubs database. We will now move on to other data sources and security.
....Read More |
Rating
|
|
|
T-SQL Programming Part 2 - Building a T-SQL Loop
|
Total Hit (1000) |
This is the second article in my T-SQL programming series. This article will discuss building a program loop using T-SQL. In addition to talking about building a loop, I will also discuss ways of controlling the loop processing, and different methods to break out of a loop.
....Read More |
Rating
|
|
|
Linked Servers on MS SQL: Part 1
|
Total Hit (913) |
Think of a Linked Server as an alias on your local SQL server that points to an external data source. This external data source can be Access, Oracle, Excel or almost any other data system that can be accessed by OLE or ODBC--including other MS SQL servers. An MS SQL linked server is similar to the
....Read More |
Rating
|
|
|
Linking SQL Server to Heterogeneous Systems
|
Total Hit (2022) |
The ability to link SQL Server to heterogeneous systems such as Oracle, DB2, Sybase, etc., is imminent. This article provides the basic and most important information required to make a linked server connection to heterogeneous systems from SQL Server. We are going to deal with three different RBBMS
....Read More |
Rating
|
|
|
Linked Servers : An overview
|
Total Hit (2007) |
Linked servers provide connectivity to external data sources, allowing you to access data and run procedures in SQL Server other than the one you are currently running on.
|
Rating
|
|