Yes if u will run MSCS for creating cluster server .... u need to install sql again..You database files will not be impacted ... you can attach uor db after...

which type of upgrade u r planning to go for... side by side or in-place.... The decision for db upgrade will be based on that. if u are planning to...

Alter command on large table take time to update. there is no other option

Hi kenneth,

No its does not require sysadmin rights to run these proc. You can specifically assign access to all 5 sp_oa .... proc. I am not getting any hint anywhere....

Thanks kenneth,

I don't want to use xp_cmdshell due to security reasons.

I didn't get any syntax related to copying or moving file @ BOL. If anyone used earlier pls. suggests.

Regards

Are u using same directory structure on server A as well as server B ? If not pls. use.

Regards