Thank you, the export/import was exactly what I was looking for!

When I cut and paste I loose all my formatting and when I paste it into excel it truncates characters!!!

Thank you!!

Thank you Noel.   Looks like I need to look at the detach/attach procedures like you said.    Thanks again

I figured it out.  and thank you for the comment on the uselessness of the count(*) !!  absolutely right!

Thanks again

Awesome !  Thank you!!

Sorry if I seem ignorant, but what is a bad practice?

Thank you one and all.   I was a little leary about changing the DB owner to another Domain Account - even one that is a member of the local admin...

Thanks, I hadn't pulled that article in my search but it seems to be related to SMS.    The other articles I pulled speak to permissions and object permissions..   I'm kinda...

Thanks much!!   I guess I don't understand why sa as db owner sounds unusual. ..  but changing them to another domain login sounds like the thing to do.  I'm just thinking...

yes, I am using sa which has sysadmin across the board on both.  That is what is so confusing to me.

I'm getting conflicting results too...

When I do   select serverproperty ('LicenseType')  against my SQL Server 2000 Instance it is returning 'disabled'  but when I go into the Control Panel and it...

There is actually a seperate SQL Server Service Pack for Analysis Services and you don't need to reapply the SP3q for Database Components.

http://www.microsoft.com/sql/downloads/2000/sp3.asp

Many Thanks!!!!!!!!