Where is ascmd.exe for SQL Server 2008?

Question

Does it even exist?  If so, where can I get it?  (I've been wandering around the Microsoft site for a half hour...  Shouldn't be that hard.)

Thanks,
Craig 

Answer 1

Hi
 The default install location for the ascmd command-line utility is :
<systemdrive_>\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\Administrator\ascmd

Here is one relevant link also
http://social.technet.microsoft.com/Forums/en-US/sqlanalysisservices/thread/94f2eac6-4c96-46b2-9127-a2765209772f/

---

D

Answer 2

This is part of the Analysis Services samples out on CodePlex that you can download -

http://www.codeplex.com/MSFTASProdSamples

---

Dan English -- http://denglishbi.spaces.live.com

Answer 3

Hi Dibyant, I think you referred to ascmd for SQL 2005 (indicated by the location of the folder ...90... ).

Dan, I downloaded the file from Project REAL, which contain the file for 
SQL 2005 version (ascmd version 9.0.83.1). 

I was able to use ascmd in SQL 2005 environment, but I am not able to find the version that is compatible with SQL 2008.

Answer 4

 Have you tried the version from here:

http://www.codeplex.com/MSFTASProdSamples/Release/ProjectReleases.aspx?ReleaseId=18652

? The readme says it supports 2008.

Chris

---

Blog: http://cwebbbi.spaces.live.com Consultancy: http://www.crossjoin.co.uk/

Answer 5

Hi Chris-
I have downloaded both the x86.msi and the .zip versions (my DEV environment is 32 bit).  Unfortunately both files do not have the ascmd.exe file I am looking for.

Answer 6

If you only have access to the BIDS components and not the development portions for .NET development then you can download and install one of the Express Editions and compile and build the executable.

http://www.microsoft.com/express/vcsharp/

---

Dan English -- http://denglishbi.spaces.live.com

Answer 7

OK, I just realize that I have to compile the file to get the ascmd.exe file.  I got the version that I need (make sure to read the Readme_ascmd.doc).  I test it and it works.  Thanks everyone.