i had a look at this.

http://msdn2.microsoft.com/en-us/library/ms178117.aspx

but when ever i try to do step 3. it fails.

this is what i do .. enable log shipping on server A as...

yes there are hugh rows exchanged > 300,000 mostly and hugh #temptables joined at the end this select * from #temptable.

i will also look into indexing the #temptables.

Thanks...

thanks. the reason is that i am new to this cmopany as dba. and the performance of 1 database has been slow for some weeks. I have to tell the...

Thanks all.. I read this in some forum somewhere but didbt pay much attention to it at that time. This person tried to create 2 differrent StoredProc and each had...

thanks guys, i used script task to check if the file exists. this link helped too - http://blogs.conchango.com/jamiethomson/archive/2005/09/14/2149.aspx

you would have to use a script task... have a look at this link. worked for me

http://blogs.conchango.com/jamiethomson/archive/2005/09/14/2149.aspx