remotely attached DB ends up readonly .. why oh why oh why ..

I have what seems like a commonish problem.
I have copied my database (mdf and logfile) to a remote XP desktop machine
... when using SQL server managment express tool when I try to attach the
DB it ends up readonly.
The file permissions are not set to read only (a problem I have read)
And I've done this shrink-detach-transfer-attach with various versions of
this database at least 20 times in the last week.
But not now it would seem.
The strange thing is that if I drop this database into the sql server default
'data' directory it works fine.
This doesnt explain why the second database that sits in the original 'destination'
directory attaches just fine.
I am utterly confused - traps for new players I guess.
---
[Sam Samson] - There is no greater folly than fixed price quoting.Sam
On the source machine, did you issue sp_detach the database? Take a look at
ALTER DATABASE... SET READ_WRITE option if I remember well
"Sam Samson" <nospamsam@.nospam.com.au> wrote in message
news:ece03a7894c38c9b916d29dee90@.news.microsoft.com...
>I have what seems like a commonish problem.
> I have copied my database (mdf and logfile) to a remote XP desktop machine
> ... when using SQL server managment express tool when I try to attach the
> DB it ends up readonly.
> The file permissions are not set to read only (a problem I have read) And
> I've done this shrink-detach-transfer-attach with various versions of this
> database at least 20 times in the last week.
> But not now it would seem.
> The strange thing is that if I drop this database into the sql server
> default 'data' directory it works fine.
> This doesnt explain why the second database that sits in the original
> 'destination' directory attaches just fine.
> I am utterly confused - traps for new players I guess.
> ---
> [Sam Samson] - There is no greater folly than fixed price quoting.
>
>

Remote cube processing

Hi,

I'm using Informatica 8 for ETL procedures and I would like my SASS 2005 to process a cube as the ETL ends.
Does anyone know if there's a component for Informatica that supports XMLA (or any other way to process the cube remotly) ?

Thanks in advance,

Ariel.

Hi,

you can use a command line tool that is avaliable from microsoft,

it is called as ASCMD.

Check this link for download and other information on ASCMD. : http://msdn2.microsoft.com/en-us/library/ms365187.aspx

Hope this helps

Regards

|||

Hi Vijay,

I'll try it on my system and get back here (it's not connected to the internet).

Thanks a lot.

|||Hi all,

Well, I checked my sytem and my ETL server is linux so I can't use ascmd because it works only on windows servers.
Any workaround or suggestions?

Thanks in advance,
Ariel.|||

Hi,

In which database is the data stored after the ETL?

Regards

|||Hi,

The DB is Oracle.
Infronatica is installed on Linux server.|||

Hi,

This is what you can do:

Set up Http access to your Analysis Server 2005.

Link to setup http access: http://www.microsoft.com/technet/prodtechnol/sql/2005/httpasws.mspx

From your Linux system, which contains Informatica:

After your ETL completes,

pass a pre-constructed xmla command (Http call) ,

to the Http access point (msmdpump.dll) of the Analysis Server 2005.

This xmla command would contain a "Process" batch command,

which instructs the Analysis Server to process a specific object (Cube/MeasureGroup/Partition/dimension).

Infact you can even create new partitions and then process them dynamically using XMLA.

xmla overview :

http://msdn2.microsoft.com/en-us/library/ms187178.aspx

xmla command for processing analysis server 2005 objects:

http://msdn2.microsoft.com/en-us/library/ms187199.aspx

In Analysis Server 2005 you would have the data source configured to get data from Oracle or whichever data stores you have.

Hope this helps.

Regards