Linked Server

Passing data between two SQL Server databases

I am having an issue to passing data between two SQL Server databases. I can not simply use Import/Export functions or Data Transfer Functions from SSIS because I was asked to transfer “20%” data with more than 15 criteria among 400 tables. Also we are not allowed to use the linked server,...

Odd problem (conversion or openquery?) only appearing in a stored procedure but not when running it adhoc

Here's the code I can run with no problems: declare @AnneeSelectionnee numeric select @AnneeSelectionnee = 2009 declare @DateDernierImport datetime select @DateDernierImport =  'Nov 14 2008 12:00AM' SELECT     LTRIM(RTRIM(T_ASFSTAG0.STANS1)),     LTRIM(RTRIM(T_ASFSTAG0.STHFO1)),...

Sybase to SQL Server via linkserver

I have set up a SQL link server between an SQLserver 2005 on a W2003 R2 and a SYBASE 12.5.0.2 server on a IBM AIX H70 system. I use the Sybase ODBC driver 04.20.00.67 The problem is than most of the times (there is no pattern ) when I select rows from a Sybase table I get ONLY ONE ROW without any...

Linked server problems

I have 2 servers Server 1 has sql 2000 (SP2) Server 2 has SQl 2000 + SQL 2005 (sp2) Im trying to create a linked server on Server 1 to Server 2 SQL 2005 I can get SQL 2005 linked into SQL 2000 on server 2 itself but when i got to Server 1 and try to create alinked server to SQl 2005 i get...

Linked Server Question

I am trying to link an existing Access 2003 password protected database to a newly installed SQL Server 2005 Express database engine. I am using the ‘Add Linked Server Access MDB’ template in Management Studio to create the linked server. The linked server is created without error, however...