My guess would be that it depends on the way security is setup for the linked server. Is the linked server passing through your credentials or is it using...

I can't duplicate the behavior. I have used EXEC sys.sp_updateextendedproperty multiple times and manually in SSMS to update an extended property and your query is only returning on copy...

We need to know more about the schema you are getting the data from so we can write a query that returns the data you need to produce the report...

Can you post your query that returns the Extended Properties? I can't duplicate the behavior, so I'm wondering if it is a problem with the query.

Are you thinking you will have multiple flows writing to the same flat file in parallel? I don't think this is possible because I think the first task to...

tresiqus (5/13/2014)

---

Well, as far as I can tell, the config option to optimize for ad-hoc workloads wasn't available in Sql Server 2000. But it's been awhile since I'd had...

The only thing that jumps out to me is that you are checking for 0 in RedExceeds and you are dividing by MaxReducedFieldAllowed so you might still be getting divide...

I'd either restore from backup or detach attach.

Yes, would like have some orphaned users (no matching login) you'd have to fix, but roles and permissions would carry over because they...

I'm surprised to see parallelism which could be part of the issue.

Is optimize for ad hoc workloads enabled on the server? This changes how SQL Server handles...

I can only answer #3. The ReportServer database has a view, ExecutionLog3, that has tracks report calls. You'd have to do the aggregation yourself. Here's a good...

The issue you are describing is because of how you have the precedent constraints configured.

You have each Execute SQL Task connected to the For Each Loop Container with...

Sean Lange (5/13/2014)

---

I don't see anything wrong with the code. I would however point out that what you are doing is very brittle. You are storing aggregate data from one...

I'm not sure I totally understand the problem as presented. Are ID and ope_number the only columns that can be different?

I think the EXCEPT operator could be your friend...

Koen Verbeeck (5/13/2014)

---

It doesn't matter if the connection that creates the temp tables is disconnected before...

This is something I've often thought about. Not having a degree in computer science, engineering, or math, I've found myself behind in theory which, at times, has led to...