yes; it worked for me.

I referred BOL for the complete syntax...

thanks a lot

I think sp_updatetstats will update stats for all tables in a db;

Still, if some one can help me to find a script for all tables in all DBs, that would...

Well, thats was lotsa info that i got...Thanks a million for all those..

I was trying to defrag the indexes only, from all tables in a DB..

But i think i typed...

Thanks MJ..

I will talk to my WIN team regarding this and let me c if i can try this..

I found Query methods for backup and restore..but couldnt get how to do thru' EM and Litespeed.

backup database MyDB to DISK = N'F:\MSSQLSERVER\BACKUPS\MyDB_DB_01_1.BAK',

DISK = N'F:\MSSQLSERVER\BACKUPS\MyDB_DB_01_2.bak', DISK = N'F:\MSSQLSERVER\BACKUPS\MyDB_DB_01_3.bak' with...

Wow!

that was a kool one.

Thanks a lot for pointing me the right one.

I tried google first...it suggested some registry stuff..But i saw some users complaning abt the registry thing too..so i ddnt wanted to try that in prod server.

Network is fine as...

Also, most of the time, the backups goes well...but sometimes it fails with the error I gave. After that, if i try to copy manually also, same error comes.

wow!

that helped man!!

thanks a lot

Ya i know about these..

But, he was mentioning like all thse are installed and running in the virtual drive and we can use this as if its installed on our...

thanks for the info...that helped..

and the OS on both machine is:

Windows Server 2003 R2 Enterprise Edition

I saw the options in google..but some places i have seen users complaining that the registry stuffs also ddnt work out..So i ddnt wanted to try those directly in my...

Thanks guys..thanks to both of you.

It throws these errors when i try to print the sql

Server: Msg 207, Level 16, State 3, Line 10

Invalid column name ' and b.cust_fin_entity IN ('JI','MI')'.

Server: Msg 207, Level 16,...