COPY DATABASE WIZARD

Hello,

I have been trying to use the Copy Database wizard, once I get through all the steps of defining the databases to use and hit finish (using SMO transfer), I get an

'Copy Database : No such interface supported'

Error and the action terminates! How can I fix this?

Regards

I am assuming you are copying both from and to SQL 2005 based databases? Not sure if Copy DB Wizard will support DMO for the older sql2000 servers.|||

Hi Raaj,

Please take a look at the existing CDW Feedback issues and either add your comments to a related one you see, or post a new Feedback Defect with the following information:

1. Source and destination server versions (8.0 or Yukon), including Service Packs.

2. Whether SQL Agent is running on either source and/or destination, and what version.

3. Whether 8.0 QA is installed on either machine.

4. A repro database attached, to either sp_attach or as a script to run. The smaller the better as long as it exhibits the problem.

We are working on CDW issues for SQL Server 2005 SP2, and are very interested in having good coverage on issues such as yours.

Ed Dudenhoefer

SQL Server Team

sqlsql

COPY DATABASE WIZARD

Hello,

I have been trying to use the Copy Database wizard, once I get through all the steps of defining the databases to use and hit finish (using SMO transfer), I get an

'Copy Database : No such interface supported'

Error and the action terminates! How can I fix this?

Regards

I am assuming you are copying both from and to SQL 2005 based databases? Not sure if Copy DB Wizard will support DMO for the older sql2000 servers.|||

Hi Raaj,

Please take a look at the existing CDW Feedback issues and either add your comments to a related one you see, or post a new Feedback Defect with the following information:

1. Source and destination server versions (8.0 or Yukon), including Service Packs.

2. Whether SQL Agent is running on either source and/or destination, and what version.

3. Whether 8.0 QA is installed on either machine.

4. A repro database attached, to either sp_attach or as a script to run. The smaller the better as long as it exhibits the problem.

We are working on CDW issues for SQL Server 2005 SP2, and are very interested in having good coverage on issues such as yours.

Ed Dudenhoefer

SQL Server Team

Converting numeric values to String in MDX

Is it possible to convert a numeric value to a string using MDX functions? I am defining a goal for my KPI and i need to display two values for the goal, (a percentage value like 75% and an actual value e.g. ￡200K) so i was thinking of converting both values to a string and then concatenate the two strings for the KPI goal. Is it possible to do this OR is there a better way of doing it?

Thanks in advance.

I'm not sure if this is the best way of handling the issue but it is technically possible. Here is a code sample illustrating one string assembly:

Code Snippet

with member [Measures].[Category Sales String] as

"*** " + CSTR([Measures].[Reseller Sales Amount].Value) + " ***"

select

[Measures].[Category Sales String] on 0,

[Product].[Category].Memberson 1

from [Adventure Works]

|||

Yes, certainly - just use the Cstr function (which is, by the way, native MDX although it behaves the same as the VBA function of the same name - see http://www.e-tservice.com/Files/vba_functions_in_as2005.doc) to cast the values to a string. For example:

Code Snippet

with member measures.test as

cstr([Measures].[Internet Sales Amount]) + " Hello!"

select measures.test on 0 from

[Adventure Works]

However, I'm not sure that concatenating these values is really a good idea. Why not create an extra dimension, or an attribute on a dimension, which has one real member and one calculated member and then allow the users to switch between slicing these members to display actual values and percentages? This is what's referred to as a shell dimension or a time utility dimension, and you can find out more about how to implement one of these here:

http://www.obs3.com/A%20Different%20Approach%20to%20Time%20Calculations%20in%20SSAS.pdf

HTH,

Chris

|||Thanks a lot this is a real life saver for me. I want to concatenate because, I am displaying these values on a dashboard and i just want to display everything on the same screen.