my question is how it can go for

seek without cont_stub and evt_stub ?

it got corrected automatically , i closed the project and restarted it again, and didnt find the problem dont know it got resolved ..its working fine now

thanks a lot

mahesh,

my understanding says, your "csd\jason" user must have equal rights on both the server. (according to ur settings db_owner on both the servers)

thanks for it

please tell me we have another option like

1. be made without using security context

2. be made using login's current security context

what do we understand...

Nagaraj

as you have told that if we have different password for sa account , it will fail

In my one of my environment, we have same sa password on...

thanks a lot

As per ur suggestion , i have select only required columns ( in below query)

select acct_id , acct_num, acct_name from tmp_account where

acct_stub = 'E0519F76-94DB-411A-8FAA-0CDA6AF046C2'

and acct_name = 'event003'

but stil...

ok thanks

how can i avoid

key lookup

give me the query

thanks

but i am talking about tuning Sql queries

if possible set up linked server again

my requirement is only to check the existence of file

Thanks to all you put their efforts , i got the resolution of it

below :

declare @nRetVal int

SET @nRetVal = ''

SET @filename = @share_unc + '\' + @filename

EXEC @nRetVal...

thanks

but any alternative for it ?

Can anyody help me ?