Also to add more onto my previous post lets say i have a col name which has data as xxx'x. now my sql is

select * from tab a

where name...

Yes there is

The port used for this server is 1434 and i created a named pipes client n/w utility for thsi IP address. Still no luck. This is a prodn server so...

I can ping the ip . I tried connecting from isql it didnt work . i tried from QA using IP address with my id and that didnt work either...

No its just that i dont know know how to use. i tried a restore from EM which didnt work. Here backups are taken by a different team of people so...

Brasuk - Although its a Litespeed backup i have the file savd as .BKP so how will it take the file name correctly if i use .LKP.

Jules - No i...

I tried both with xp_restore_database (where litespeed dll is used) and also with restore database but none works. works well for a .bkp file which is empty i mean no...

Thanks Lucky but i tried what you had sent and this is what i get.

The file on device 'd:\aaa.bkp' is not a valid Microsoft Tape format backup set.

Restore database in...

Can anyone please tell me what the below statement means.

SELECT @BkpString = 'RESTORE DATABASE [' + @RestoreDBName +

 '] FROM DISK=N''' + @Bkpfile + ''' WITH FILE = 1, NOUNLOAD, RECOVERY, REPLACE,

 MOVE...

Thanks Jimmy.Do you have the piece of code which i can look into?

TIA

Thansk Jimmy, But is there a that i can switch to a step if its fails something like you do a go to  in stored procs in sql same way...

oops never realised if my mail was not complete. heres the error that i see on my distribution msrepl_errors table.

Time-out occurred while waiting for buffer latch type 2...

Thank you so much. That worked very well.

Can you please let me know how to do that. Check for the file existance where ??thanks

Yeah close to 23 table son one publication and alll works fne except for couple of table which arent getting replicated. anyone else has seen this happening. TIA