Browse by Tags

FIX: Error message when you try to create an Oracle publication by using the New Publication Wizard in SQL Server 2005 Service Pack 2: "OLE DB Provider 'OraOLEDB.ORACLE' for Linked server <LinkedServerName> returned message"

Published 19 August 7 4:40 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX: Error message when you try to create an Oracle...

Filed under: sql server, replication, kba, service pack2, oracle, linked, publisher

Linked server import problem- Convert FLOAT to Varchar or char or even to INT data type?

Published 12 July 7 10:11 AM | SSQA.net

I have received a question via email asking for a solution, though solution is simple thought I can blog it. We have a simple linked server connection to import data from a provider.When querying a comma delimited file, why does sql server try to interpret...

Filed under: sql server, ssis, linked, convert, str

FIX: Error message when you commit a distributed transaction that contains a query that retrieves data from a linked server in SQL Server 2005: "Transaction manager has cancelled the distributed transaction"

Published 9 July 7 3:55 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications FIX: Error message when you commit a distributed...

Filed under: sql server, server, kba, transaction, linked

Can't find linked server in management studio?

Published 28 June 7 9:41 AM | SSQA.net

In SQL Server 2000 when you create a linked server then you can see that on Enterprise Manager under Security --> Linked Server. One of the Developer asked me how we can find same in SQL Server 2005 Management studio, here it is: You will find under...

Filed under: sql server, management, security, server, ssms, enterprise, sql express, oracle, linked

FIX: Error messages when you run a query against a linked server that you create in SQL Server 2005: "Statement(s) could not be prepared" and "The column prefix '<column_prefix_name>' does not match with a table name or alias name used

Published 27 June 7 11:52 AM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX: Error messages when you run a query against...

Filed under: sql server, server, query, kba, table, linked, alias