I would check on the credentials used to set up the UCP. @Brandie, UCP is a way to monitor several SQL Servers from 1 and set up a data warehouse...

Is your browser service started and are the proper ports open on the firewall?

64-bit or 32? If 32, is your /3GB switch on? http://social.msdn.microsoft.com/forums/en-US/sqlanalysisservices/thread/21bf84c5-f89a-464a-a5f1-2649fae5eb1e/

cw.izatt (2/16/2012)

---

After thinking about it...

Are the linked servers read-only? Replication may be an option, or a DML trigger.

AND no conspiracy! 🙂

So I just took your case statement and put it at the end. Can you run it and tell me if it works? You never gave us your updated...

tcarcieri (2/16/2012)

---

Cadavre,

You ARE a GENIUS! That is exactly what I am looking for.

I can follow it a little but would you be kind enough to explain what is happening in...

Why not? SQL is perfectly capable of handling it and if it is a dedicated SQL Server it...

Glad to help!

My guess is that the result for 1441 should be 24:01:00. It seems, looking at this post and the other post by the OP, that this is a duration...

Going out on a limb... Do you have the ability to stop the data from being stored as a VARCHAR in the temp table and actually use the type that...

How big is the file that you are sending? Can you mail server handle/allow the size?

Certainly sounds like parameter sniffing. Can you post the DML for the query? I'd like to see what is going on there.

Did this work for you? Also, does anyone else have a better way to do this?