Pls see the KB article from Microsoft

http://support.microsoft.com/kb/972200

Hey thanks for that...

it really helped me...

i dont know about that.. can u help me which level to keep..

thanks

- Kerobin

i'm using SA sql authentication for both servers..

Thanks

- Kerobin

Hey

Am sorry..!!

That table name is not #TempWeeks1.. its #TempWeeks

I update it again...

Can u look at it now..??

Thanks again!!!

Hey Tommy

Thanks.. its workin well...

/Kerobin

here is my code...

"C:\Program Files\Idera\SQLsafe\SQLsafeCmd" Backup "Converted - VMWARE Virtual Center" "D:\Backup\toursdb\TOURSDB_TOURSDB_Converted.safe" -server "TOURSDB" -instancename "TOURSDB" -backupdescription "Converted - VMWARE Virtual Center" -backupname "Converted - VMWARE Virtual Center" -verify -init...

515811Select Distinct sub.Subscriberid        ,m.Memberid      FROM ET_Main.dbo.Members m With (Nolock)        Inner Join...

Thank you so much Ken... ur code is workin perfect...

and i got very less reads as...

(0 row(s) affected)
Table 'Worktable'. Scan count 0, logical reads 0, physical reads 0, read-ahead reads...

Here is the query...

UPDATE #ProducedHour  SET                       ...

Thank u so much larsson...

it really worked out well...

Thank u so much...

ya just empty string..

it is givin the results correctly but only issue is the performance..

i hav index in email column..

Hi Peter,

It is not like dat.. i need to get the rows which doesnt hav any email contact..

And email column is not unique..