SQL Server Deployment Property (Retain Configuration Setting)

  Well one of my customers had asked the as significance of this property as he didn’t find anything on net so thought of writing an article about it. http://blogs.msdn.com/b/karang/archive/2010/08/16/sql-server-deployment-property-retain-configuration-setting.aspx

0

How to Deal with Corruption in Analysis Services

  I had seen few scenario where you perform any action on Analysis Services you get weird Error Message like some store is corrupted Sample Error: An error occurred when instantiating a metadata object from the file, ‘\\?\J:\Program Files\Microsoft SQL Server\MSAS10.SQLInst\OLAP\Data\dbDev.0.db\testdim.2.dim\DimensionPermission 1.0.perm.xml’. http://blogs.msdn.com/b/karang/archive/2010/08/11/how-to-deal-with-corruption-in-analysis-services.aspx [All the posts are AS – IS and doesn’t carry any warranty]

0

Running AS Command(XMLA / MDX) as a Batch Job Using SSIS Package

– Get ASCMD for right version 2008 2005   -Create a file with XMLA / MDX Command and give extension as xmla/mdx   -Create one batch file with command with text as d:\asjob\ascmd -S karan2k8-64\sql2005 -i d:\asjob\backup.xmla In my instance- ASCMD is located in D Drive ASJob folder that’s why I had given it in…

0