Showing posts with label determine. Show all posts
Showing posts with label determine. Show all posts

Friday, March 30, 2012

How to verify if 64 bit client tools are installed

Hi,

I would like to know how can I determine if I'm properly using 64 bit client tools for SQL Server? I have just installed SQL Server 2005 64 bit and I can see on the Add/Remove Program "Microsoft SQL Server 2005 (64-bit)". However, when I open SQL Server Management Studio or Business Intelligence Development Studio, I see the following on the Task Manager:

SqlWb.exe*32

devenv.exe*32

Thanks,

May Lanie

The client tools are 32bit. There are no 64bit Client tools publically available.

Friday, February 24, 2012

How to use AMO to determine if a cube is being processed by another user?

Hello,

We have a cube in AS2005, and it is going to be used by multiple users. The users will all have the ability to process the cube by clicking on a button.

Is there a way to to use AMO to check whether the cube is currently being processed?

Thank you very much,

Hsiao-I

This is pretty easy. Take a look at return value for the State property of the major objects.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.