SSRS does not have a view on what executes inside the sp. so in theory what all possible for the user account running the query.

sorry for replying late.

As a temporary workaround you can use SQL authentication saved inside your connection manager. Delegation issues happen only when you connect from a different machine. Why don't...

First, It is not advisable for you to mention your server/ credential names in a public forum 🙂

The issue happening for you here is the delegation does not work for...

In sys.processess does your waitresource show something like 2:1:1. It might be a tempdb contention.

You are not doing anything wrong. If not opened in SSRS project, rdl reports are just xml files. However you can import all of these reports into a project and...

If you are able to use SSIS, there is a task available.

https://msdn.microsoft.com/en-us/library/bb895263.aspx

I am not sure you should completely rely on DTA for performance optimisation that too...

Does it succeed after some time?, Can you find your session sys.dm_exec_requests? what is the status and waittype ?

itguy2015 (11/18/2015)

Here is a screen shot of the services. Note that where I...

What do you see when you execute select @@servername from both the instances. I think they both pointing to same instance.

Edit: I mean some alias name

Great idea, thanks for taking time to share your work.

TSQL Tryer (11/13/2015)

I have three fields in my query - ContactGroup, Contact and RelationshipID

All 10 entries are part of the same ContactGroup.

ContactGroup Contact RelationshipId

ABL001 ...

Great topic to discuss,

I have played all kinds of roles for SQL developer, DBA and data modeler and I have always found schema very useful for logically separating the objects...

Jeremy's script wont alter any database,

you need to select the out put of the query and run it in another query window.

You can develop dynamic query on top of...

entertaining and informative. I have used rename and partition switch. I think rename is good if its a one time load. Partition switch is something that can be created as...