Thank You ALZDBA

Regards

P.Prakash

CREATE TABLE Master

(MasterId int, MasterDesc varchar(2000))

CREATE TABLE LineContent

(PageNo int, PageLineNo int, Content varchar(2000))

sorry i can't give data becos its my companies.

thanks

prakash

Hi,

i have created nonclustered index in both tables. In "MASTER" i have created non-clustered index for masterdesc column similarly in "LINECONTENT" table i have created non-clustered index for "content" field....

Hi,

i have attached the estimated execution plan. actual execution plan is taking long time

regards

p.prakash

Thanks you very much for your reply i'll look in to it

Hi Wayne West,

Thanks for your reply.

one thing i want to tell you that if i create a file to that remote location using bcp its creating so...

Hi,

I want to download files from PSFTP to my local directory. this work has to be done in stored procedure sql server 2005.

i tried creating a...