Log-Shipping copies the entire transaction log backup to your backup server and restores it, therefore it is a perfect copy of your source DB.

If you need only certain tables then you...

• Ensure MSSQLSERVER and SQLSERVERAGENT services log on using the same account ("Domain\User")
• Install MS Outlook
• Log on to PC as "Domain\User"
• Open Outlook and Configure exchange settings
• Open Enterprise...

Personally, I find the hardest thing about moving on from a job is leaving your co-workers in the lurch... the feeling of guilt soon evaporates when you start getting your restful sleep...

You need to enclose the project codes in single quotes, as it stands the query is looking for columns called C, c etc. because the double-quotes are column identifiers, should...

and there it is for all to see...

mediacode1,length

--------------------

Ultra Eyecare

,15

Ultra Eyecare,13

(2 row(s) affected)

Many thanks Sergiy...

LF's shouldn't really exist in this data, I guess...

Thanks Noel,

ufortunately this results in the same error message - I will have to have our Spanish friends re-write the stored procedure.

Cheers,

Paul

Many thanks for all reponses;

the suggestion from noeld:

insert #tmp

select * from openquery ( <linked_server> , 'SET FMTONLY ON; exec <db>.dbo.sp ''2006-03-13'', ''2006-03-14'', 1' )

resulted in:

Server: Msg 7357, Level 16,...

Hi Tim, have tried "set nocount on" ( openquery would not allow set ansi_warnings off) with the same results, complete syntax of the remote sp as follows;

CREATE   PROCEDURE CLI_IPACK_UK

(

@INICIO DATEtime,

@FIN...

Hi Tim,

I've located the cause of the problem, the sp on the Spanish server is not a simple select, the final statements in the sp are;

...

--first part writes all query...

Hi Tim,

connection re-established... reaults of using openquery as follows;

Server: Msg 7357, Level 16, State 2, Line 1

Could not process object 'exec cd01.dbo.cli_ipack_uk '2006-03-13', '2006-03-14', 1'. The OLE DB provider 'SQLOLEDB'...

Many thanks for the suggestion Tim,

However, the Spanish link has just gone down!, I'll try your suggestion as soon as possible....

Have you used bcp successfully before? If not it may be a permissions issue. If bcp is attempting to write the files you should be getting some feedback from Query...

I would suggest using Group By;

select CustID, ProdId, sum(Quant)

from Orders

Group By CustID, ProdId

Hi Arindam,

you  could try this;

DECLARE @bcpResult int

DECLARE @bcpCommand nvarchar(4000)

DECLARE @ifile_id integer

DECLARE @sfile_id varchar(3)

create table ##temp

(

col1, -- as <source_table>

col2, -- as <source_table>

col3, -- as <source_table>

col4, -- as <source_table>

col5, -- as <source_table>

col6...

Thanks Wayne,

I'd come up with this since submitting the post;

select fu.* from dbo.followups fu

inner join

(select customer_id, max(followupID) As maxFollowUp

from dbo.followups

group by customer_id) as fuLatest

on (fu.customer_ID = fuLatest.Customer_ID AND fu.followupID =...