That suggestion isn't too far-fetched; like you said it sounds difficult but I can imagine how that could solve the issue. We'd have to disable function inlining in 2019 to...

Thanks a bunch for the reply. the TRY CATCH block is an awesome idea, i think we can start doing that right away. Great suggestion.

We had been looking at the...

...By the way... we did ask Microsoft support for their thoughts on this, and they offered one nugget that didn't help us, but might help someone else.

They suggested that in...

The solution to your problem, johnnyk, is the same. Convert the DT_TEXT field to a DT_STR. If the field is unicode, convert the DT_NTEXT to DT_WSTR, then convert the DT_WSTR...

Good Question. Was just working with this scenario...

So, if I am understanding correctly, you don't want just

SELECT MAX(A), MAX(B), MAX(C) FROM test

You are looking for the max of A, and for all B values associated with...

I agree with GSquared. Combining 2 different groupings into one report and trying to control them via parameter could get ugly. If you insist on doing it this way, I'd...

Hey, sorry for the *very* late response, i was out of town...

You grant the domain user group (in this case USERS\USERS) permission to the "Home" folder inside SSRS. when...

I've noticed this behavior too; as far as I know there isn't a workaround. In my situation I decided to just create a separate db_datareader only login for the reports...

Or, you could just use reporting services scripter, which is free... but hey good scripting effort

http://www.sqldbatips.com/showarticle.asp?ID=62

Such a bummer to me that the sp_change_users_login option is going to be phased out without a "decent" alternative - consider the scenario that exists in my environment where there...

chrisn-585491 (2/1/2011)

---

The only "Passive Server" would be one that had no-commercial software requiring paid licenses. This would exclude any offering from Microsoft, Oracle, IBM, etc, but I believe PostgreSQL running...

Are you sure the problem is occurring just over VPN? Have you isolated all the variables?

I had a very peculiar issue with a new SSRS instance that was similar to...

I don't know if our implementation would necessarily fall under "Best Practices", but it does prevent us from managing hundreds of individual sql server logins based off of people's individual...

In our implementation of SSRS we use a separate, hard-coded sql server login in the data source for reports to run through, that regular uses dont have access to, and...