the question should read for index creation, but a good question.

Run a trace , find the hostname and IP address

Since its a SQL login the password is hardcoded somewhere this means its either coming from a connection string in...

In that case I think you need to use the PIVOT Syntax within t-sql

@jeff Looks like a perfect example on using dynamixc SQL 🙂

Its better to run a trace and capture the Ip and hostname first , do you have any other instances on the server ? Have you checked the windows event...

You could use a trace to filter for the login name , I would recommend audit only if you plan to implement it fully not as a way to troubleshoot...

http://stackoverflow.com/questions/20057655/multiple-rows-in-one-column-sql-server

Have you seen this ?

+1 Jeff , Developer over Express any day , infact you just used one of the the most common examples i give when people ask about learning sql

I should have been more clear about my points , sorry . My point revolve around the self service aspects of MSBI.

Its more difficult to implement singlesignon in SSRS...

Native comes out of the box so there is no additional cost associated.

Native is simple to use and setup

Native can be embeded in Webpages using Report viewer control

Sharepoint provides a...

In your expected output i see there is a comma delimiter between strings, is this the way the data is stored or added by you when posting the query?

if there...

I think it was added in the last sevrice pack for 2008 R2, it came out of the box with 2012

Could you please post the query

CROSS DATABASE TOOLS !!!!!!!

Be very careful when using generic tools to script out code for production deployments. I would frankly use Data tier application before I even consider using a...

are you sure its the mDX thats causing the issue, why are you not using the same MDX query in both cases? SSRS performs rendering of the report in...

Nope dont think so , atleast not within SSMS , might be easier to script out the file and do a replace later.

You Could use powershell to replace the string...