it worked . thanks a bunch

will do thanks

indeed most of the fields contain null value.. i did not think about that.. any ideas of how to program around this?

are there any other tools that anyone else could recommend?

thanks charles!...okay so maybe i got a bit emotional. i do admit that enterprise manager has served me well. i just need something right there, without having to do much...

Thanks all. i will try that. i hope it works. i will keep y'all posted.

actually, none of the above apply . but i guess i will just go back to the old method of using dts to get the data out daily . i...

Thanks

Thanks ...will do

still on the moving files issue, after i fixed the dependency issue, i then tried to move the log files for a database (as test).,

i did the following,

chnaged db...

Thanks Brian

thanks, will do.

as an aside question, is there away to know what the sa password is? or do i have to use t-sql to hange the password. the problem with...

this is weird, but this is inherited mess. i mean, the cluster was created a year ago and sqlserver was installed on it. since the person that creatd it is...

Thanks all. wish me luck!!

now see. that is a great suggestion. i will let you know if it works