You could embed an iframe in your webpage, which fires off a request to the SSRS server using impersonation of a windows account which has access to the folders etc.

Look...

Re-write them in BIDS, you can't run Crystal files in SSRS.

What version of SQL are you running? Enterprise or Standard? If Enterprise look at data driven subscriptions, if Standard then you will need to create a lot of...

Can you attach the execution plan in a .sqlplan format?

Also can you complete the problem you are facing as it seems the original post isn't complete

SQL Build list

http://sqlserverbuilds.blogspot.co.uk/

You could try the default trace, but it might have rolled over by now so you might not get the answer.

Other than that do you have custom auditing in place?

Do...

Check to see what your biggest tables are, monitor them for duplicate entries if something is stuck importing the same file over and over etc it will upload the same...

If the data file is growing rapidly, you need to check is this normal behavour? do you have a run away process which is looping through the same task...

Are the rpt files outside of a solution or are the inside a solution.

If inside, then you can simply use the automated deployment from within BIDS to upload to a...

Also a Central Management Server will do the trick.

I would strongly recommend changing your column to NVARCHAR(450) to prevent any insert/update failures.

But if query time has increased after adding the index, then the index doesnt help.

Is dbo the right schema?

Yes, but no.

Assuming that all the length of the strings are less than 450 characters it will work.

An indexes key length is 900 bytes, now as NVARCHAR(MAX) can go above...

It is best practise as its the most secure method of handling authentication due to the way it handles tokens and requires authentication from AD, which is that little bit...

Peter Waters Dingley