oh, i thought that will help to clear the cache ... one of online post was though suggesting to schedule it twice a day..Thanks, i won't run that..

What about force...

Thanks, i am doing similar sort of stuff within SQL Server. but with two Jobs on to take backup and second to copy file across and restore it.

The only drawback...

I was returning result into grid but when i was clicking on blue xml it was throwing and error

Unable to show XML. The following error happenend.

Unexpteced end of file...

Oh, you are star, that's exactly what i wanted.. :).. one last thing, actually two 🙂 ... it is showing following characters end of each line & # x...

Thank for the script, is there anyway i can run one table at a time ? i mean a where condition with table name?

i had the similar issue and now i am using following technique to rebuild indexes which are only required to be rebuild.

1. Check the fragmentation greater than 30% and pages...

any way thanks for your reply.. atleast i got the idea. now i will try to do by myown self.. thanks......

Thanks for your prompt reply..

it's only returning the first row of result table..

i have checked into userteam table. that the record that has only one row. it's not returning anything,...

THANKS.

i think there is some network issue is going on....

thanks guys..

acutally i was planing to restart services every month.. acutally tempdb get's bigger and bigger.

so i thought it' good pratice

but what u think , is it good pratice ?

is there any alter / email programm that i can setup to automatically inform me, if something goes wrong...

acutally my database is access by web and so many resquest come...

Hi Kevin.

thanks, it's works..

Thanks alot.............................

Thanks all of you guys. helping me..

this conversation really helpfull for me

Thanks........

actually what i want to do..

i just want to genrate the key from primary table1 and then take key to Table2...