Zidar- Awesome. You replied like you read my mind. 
I...

Since there is a requirement I have to bring the dataset like I mentioned. Can you help modifying the data like I showed whenever a new name is given to...

Thank you very much. It worked.

I have a column 062008 I want to display that number as 06/2008.

Also check anti virus scan!!

Also check anti virus scan!!

when I research online, ppl are following;

Dual Replication/Log shipping:

From 2000 server to 2005/2008 and from 2005/2008 server to 2012 server.

Yes

For Win 2008 and 2008 r2

http://social.technet.microsoft.com/wiki/contents/articles/5752.how-to-grant-users-rights-to-manage-services-start-stop-etc.aspx

I found this on Win Forums...

By default, only members of the local administrators group can start, stop, pause, resume or restart a service. To grant non-administrators the ability to manage...

what is the point if we keep creating alias in each machine that uses this alias name? Is there a procedure where we we create a alias in one...

You are right! How about the application? I mean app is not able to recognize the alias name.

One more doubt in my mind; what is the point if we...

Thanks Perry.

Moving SSAS instance from a server.

First take Cube bakups.

next apply them to destination server (double check src (ware house it is using)).

Make sure you change to new server name in...

Agreed Guys. Thanks for the response.

How about storing the key and cert in a folder with unique security to that folder.

What do you guys think ?