Archives for February, 2012

Adapt location when creating a SSAS DB


Add <ddl100_100:DbStorageLocation>D:\SSASDATA\</ddl100_100:DbStorageLocation> to your CREATE Database XMLA script to overwrite the default DataDir storage setting. Advertisements

Disable AUTO_SHRINK


Disabling AUTO_SHRINK has only immediate effect if you put the DB first in single user mode: USE master; GO ALTER DATABASE MyDB SET SINGLE_USER WITH ROLLBACK IMMEDIATE; GO ALTER DATABASE MyDB SET AUTO_SHRINK OFF GO ALTER DATABASE MyDB SET MULTI_USER; GO