Atlanta Custom Software Development 

   Search        Code/Page

User Login



Forgot the Password?
» Web Development
» Maintenance
» Data Integration/BI
» Information Management
VB VB (1648) (736)
C# C# (15) (779)
ASP ASP (41)
VC++ VC++ (25)
JScript JScript (5)
» SQL Server (708)
» ORACLE (5)
» MySQL (0)
» DB2 (0)
» C/C++/ASM (11)
» Microcontroller (1)
» Circuit Design (0)
» Networking (5)
» Unix/Linux (1)
» WinNT/2k/2003 (8)
» Flash (0)
» Maya (0)
» 3D max (0)
» Photoshop (0)
» (2)
» PC Interfacing (1)
» Networking (4)
» SQL Server (4)
» VB (23)
» (4)
» VC (3)
» HTML/CSS/JavaScript (10)
» Regular Expr Tester
» Free Tools


How can I drop a table on a Linked Server ?
Total Hit (2429) 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
PRB: 7357/7320 Error While Performing UPDATE, INSERT, or DELETE on Remote Table Using OpenQuery Via Linked Server
Total Hit (8211) «B»PRB: 7357/7320 Error While Performing UPDATE, INSERT, or DELETE on Remote Table Using OpenQuery Via Linked Server«/B» This article applies to… This article was previously published under Q270119 «B»SYMPTOMS«/B» Distributed queries that use the OpenQuery function to update, delete, or i ....Read More
How to Fix Inconsistent Metadata Errors (SQL Server 7.0)
Total Hit (3137) 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
How to perform update on multiple tables of linked server.
Total Hit (2371) 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
Linked Severs on MS SQL Part 4, Oracle
Total Hit (2239) 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
How to add/configure a new Linked server using T-SQL
Total Hit (8235) 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
Error : "The provider could not support a row lookup position....."
Total Hit (5139) Sometimes when you try to do update/delete or insert on linked server you might get the following error. «font color=red»Server: Msg 7306, Level 16, State 2, Line 1 Could not open table '"Mydb"."dbo"."myTable"' from OLE DB provider 'SQLOLEDB'. The provider could not support a row lookup po ....Read More
This is a link to a different site Linked Severs on MS SQL Part 3
Total Hit (993) 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
This is a link to a different site SQL Server: Calculating Running Totals, Subtotals and Grand Total Without a Cursor
Total Hit (919) If you have ever had the need to show detailed data of individual transactions and also keep a running total, subtotals, and grand total columns at the same time, but were not exactly sure how to tackle the problem then this article might help. In this article I will show you a few different techniq ....Read More
This is a link to a different site Linked Servers on MS SQL Part 2
Total Hit (947) 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
This is a link to a different site T-SQL Programming Part 2 - Building a T-SQL Loop
Total Hit (948) 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
This is a link to a different site Linked Servers on MS SQL: Part 1
Total Hit (853) 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
This is a link to a different site Linking SQL Server to Heterogeneous Systems
Total Hit (1925) 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
This is a link to a different site Linked Servers : An overview
Total Hit (1891) 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.

Recommanded Links


Home   |  Comment   |  Contact Us   |  Privacy Policy   |  Terms & Conditions   |  BlogsZappySys

© 2008 BinaryWorld LLC. All rights reserved.