Hi,

   i tried the otherway too..ie @strsql='insert into'+@vtbl+'values (15)'

   Yes..ofcourse this is just a sample piece..but i have a scenario where i need to take a  variable of table...

hi rookie,

    thanq for the reply...how can i take the log backup immediately after failure occured ? becoz the database is in suspect mode...?

nsr

Thanq steve ..i got clear with the topic..

Hi steve,

    Thanq for the reply..thats great.. i just need some clarity over here...

1.  AS '[Product].[All Products].[Drink]+[Product].[All Products].[Food]'

     For this is there any alternative to get...

hi steve,

   one more help... how can i script the metadata in analysis services ? is there any utility ?

nsr

hi steve,

   thanq for the reply..the problem is becos of insufficient rights to the  \program files\analysis services\bin direcotry for OLAP Administrators.When i gave full rights its working fine....

nsr

hi martin,

   thanks for the reply.. so in either of these cases a and b (1,2) complete recovery of data is not assured right ? i mean the workdone between...

hi karthik,

  tq for the reply..pls see hereunder the log output..

Microsoft SQL Server Merge Agent 8.00.760

Copyright (c) 2000 Microsoft Corporation

Microsoft SQL Server Replication Agent: ERPSERVER-mejdafERP-mejdafERP-AL-KHOBER-4

Percent Complete: 0

Connecting to Distributor 'ERPSERVER'

Connecting...

yeah..it worked well..tq v much

Hi,

  clients can access the database residing in a remote machine. This is possible by registering a new server in EM (client machine) based on machine name or ipaddress of...