Do i need to manully save all the 150 packages.....is there any autmated way for this ?

Regards

Nimesh

Thanks Very much...

I also found another way to do this....

When you create a new login in SQL don't use Browse dialog box to search Active Directory accounts. Instead manually type...

-connect to target SQL server via RDC using your admin equivalent domain account

-changed local security policy "Security Option: System cryptography: Force strong key protection for user keys stored on computer"...

this was related to one of the domain policies in place. as a work around, please raname the schannel registry and give a try....

Regards

Nimesh

But this does not tell me what all may be the daily activities i should do with the analysis service instances...

Just start your sql server in single user mode using sqlservr -c -m...this will allow you to re-add the Builtin\dminstrator account....

this is a design flaw in sql server which you...

you can run a profiler under a job to monitor the DDL changes....

Regards

Nimesh

Hi,

I did the following to resolve the problem

Steps while restoring a publisher

• Take a native backup (with out using LiteSpeed) of the database to generate the backup file for...

Good Article.

One of my doubt is still unanswered about truncate

Will you be able to recover data of a table after truncating it ?

Regards

Nimesh

sorry,

that was not the error that i was getting...my error is different from that

Hi,

You can use DTS import exort wizard to take the table content. Export the content of the table to a temp table. But this will cause problem when the table...