Showing posts with label advice. Show all posts
Showing posts with label advice. Show all posts

Thursday, March 29, 2012

Error Relational and OLAP Engine

Hi Edward,

What is wrong with my cube?

The dbo.Prescription table is in the data source view.

Please advice

Ronald

You are receiving a message during processing of one of your partitions: 'Prescrition'

The error indicates your server cannot find the source table for your partition.

In the previous post I suggested you modify source table for partition 'Prescrition'.

Have you tried it? Did it work?

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Sunday, February 26, 2012

Error message using "Copy Database Wizard"

Any advice from the crowd? Every time I try to run "Copy Database
Wizard" I get an error message saying I must be a member of the
sysadmin group and have permission to copy files over the network. I'm
a local admin on both boxes and a member of the sysadmin group on both
SQL servers and an admin on the network. What am I missing here?

Thanks,

Ralph Noble
ralph_noble@.hotmail.comIs the target server running under a domain account? Check out:

http://support.microsoft.com/defaul...463&Product=sql

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Ralph Noble" <ralph_noble@.hotmail.com> wrote in message
news:ed6de1e7.0411110741.15429731@.posting.google.c om...
> Any advice from the crowd? Every time I try to run "Copy Database
> Wizard" I get an error message saying I must be a member of the
> sysadmin group and have permission to copy files over the network. I'm
> a local admin on both boxes and a member of the sysadmin group on both
> SQL servers and an admin on the network. What am I missing here?
> Thanks,
> Ralph Noble
> ralph_noble@.hotmail.com