Hi Vijay ,

Are u backing ur database through maintinence plan.

if yes then u might have enables the  check integrity  before backup. This is a bug and issue have resolved in...

Hi,

I got the same error.

I installed the client tools only but now the error is diffrent.

No default instance.

So, i registered the DSO files but stil the same error.

from

Killer

Hi,

No dts jobs closes the connection as the job completes. u can query sp_who to see that ur dts still have connection or not ( i mean running query).

Yes sure...

Hi,

No, db owner not changed.When  we install Microsoft Navision Axapta it creates a login BMSSA in sql server.

Hope this is more clear.

from

Killer

Hi,

What version of Sql Server do u have installed on server.

This problem is fixed in SP4.

from

Killer

Dear Shashank,

Thanx for ur reply.If u have gone through the discussion then u might have see that it is not a orphand login because we execute some dml commands from Navision...

Hi ,

No server role is assigned .

No database access permission assigned.

How can be bmssa behave as alternate sysadmin account with no server roles and no database access permissions.

from

Killer

Hi ,

I looked it as an orphand user but we can use our application from bmssa login and even syncronise table and doing reindexing sometime.

but now we change over to...

HI,

Is there enough space on the disk u r backing up the database.

from

Killer

Hi,

Do the database in readonly state or single user mode.

from

Killer

Hi,

I tried and experienced that if u have shared dimensions then the copy works fine in the same analysis manager in diffrent databases or in same database name.

but if the...

Hi,

Try upgrading it to sp4.The issue had been sloved in sp4 sql server.

From

Killer

Hi Chris,

Go to Administration manu then to services and try from there to restart ur agent.If it is still not stating then see the settings in sp_configure.

from

Killer

Hi,

Go through this link it will definately help u

http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlorcle.mspx

Hi Suresh,

U can easily tranfer the datatype to Oracle (BLOB,CLOB, Image) from ODBC connection string.

from

Killer

Hi Vikram,

Download the oracle migration work bench and it will do it for u.

It is free in download option of Oracle.com(omwb.zip)

Blob datatype field is stored by default in system tablespace and...