Deleting a database

Deleting a database

• Alex_Petrovic

  Hi

  In MSAS 2k ,You can a write a VBSCRIPT using DSO object in DTS for deletion of OLAPDB.Then run this DTS from DTSRUN "DTS Package name" from commnad line.

  Thx and regards

  Pankaj

  
  

• Learner006

  And if you are using Analysis Services 2005, you can write this C# application based on AMO (the management object model for AS2005, successor of DSO from AS2000):

  (to reference AMO, use Microsoft.AnalysisServices.DLL from "%ProgramFiles%\Microsoft SQL Server\90\SDK\Assemblies")

  using Microsoft.AnalysisServices;

  ...

  Server s = new Server();

  s.Connect("localhost");

  try

  {

  s.Databases.GetByName("My Database").Drop();

  }

  finally

  {

  s.Disconnect();

  }

  
  
• Deleting a database