some time i m hving I/O problems, but processing is too slow. now the server is working bit fine .. and i hv get the result..

SQLServer:SQL Statistics ...

Thank for reply.

no my database is not in recovery mode..and also i m taking regular schedule back..

Thanks for reply..

it's similar to that.. but the code and the out put is on table level and it's concern about data... but i m looking actuall structure of the...

Thank for reply.. please find blow the code that i want to execute.. when the value goes more then 8000 charater it's give error and procedure can't able to copy...

but mate you gave me three options. i chose the first one. y not i go the one i like. i hope it's good to me to learn some thing...

hi

Thanks for reply, i will go for the Option 1, seriouly i dont' have a single clue about this. Can you tell me more about this in detail.i love...

Thanks i have solved the problem...

-MALIK

Thanks for the reply, but after executing the script you send i m getting this error message.. do u hv any idea

Msg 7411, Level 16, State 1, Procedure MODIFIEDPROCEDURE, Line...

you can create a job to make a schedual backup of yourdatabase, if you r running a sql server 2005

if u dont' mind can i ask one more question.

is there any code or script that can be used to create a copy of Database with new name and location....

thanks. it's working now