BI Accelerator SMA

Hello people,
I want to inspect the code corresponding to the "BI Accelerator - SMA
Application" But I dont have the password to do this va MS Excell. Anyone
of you know how to do that.
Thanks. Federico Haedo
Unfortunately we don't release the source for the BI Accelerator MS Excel
code. Sorry.
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Federico Haedo" <fhaedo@.harriague.com.ar> wrote in message
news:OBygmwTrEHA.324@.TK2MSFTNGP11.phx.gbl...
> Hello people,
> I want to inspect the code corresponding to the "BI Accelerator - SMA
> Application" But I dont have the password to do this va MS Excell.
Anyone
> of you know how to do that.
> Thanks. Federico Haedo
>

Best way to confirm password change for a Credential?

Looking for opinions here on what is the best way to programmatically test that a password change to a credential has occurred successfully.

The password change was made using Alter Credential, and I can see in sys.credentials that the credential was updated by the tool that handles these updates. I would just like to be able to confirm that all of the credential updates were successful (in other words, they authenticate correctly) before anything starts to fail.

Assume that the number of SQL Servers is too great to manually check them even if the whole team worked on it together.

Thanks in advance!!

I think there is no such DMV or DMF available in this case and for multiple servers you might need to wrap in to a stored procedure to execute on relevant servers using SQLCMD scripts & variables.