Viewing 15 posts - 1,666 through 1,680 (of 2,647 total)
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...
February 16, 2012 at 12:23 pm
Is your browser service started and are the proper ports open on the firewall?
February 16, 2012 at 11:58 am
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/
February 16, 2012 at 11:53 am
cw.izatt (2/16/2012)
Why not? SQL is perfectly capable of handling it and if it is a dedicated SQL Server it is probably the best tool to use.
After thinking about it...
February 16, 2012 at 9:45 am
Are the linked servers read-only? Replication may be an option, or a DML trigger.
February 16, 2012 at 9:28 am
sturner (2/16/2012)
Welsh Corgi (2/16/2012)
Your code worked.Sorry everyone.:blush:
phew. At least we know there isn't some obscure unreported SQL server bug. :hehe:
AND no conspiracy! 🙂
February 16, 2012 at 9:24 am
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...
February 16, 2012 at 9:01 am
tcarcieri (2/16/2012)
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...
February 16, 2012 at 8:47 am
cw.izatt (2/16/2012)
I agree with above, why handle all of that inside SQL?
Why not? SQL is perfectly capable of handling it and if it is a dedicated SQL Server it...
February 16, 2012 at 8:46 am
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...
February 16, 2012 at 8:29 am
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...
February 16, 2012 at 8:21 am
How big is the file that you are sending? Can you mail server handle/allow the size?
February 16, 2012 at 8:16 am
Certainly sounds like parameter sniffing. Can you post the DML for the query? I'd like to see what is going on there.
February 16, 2012 at 8:14 am
Did this work for you? Also, does anyone else have a better way to do this?
February 16, 2012 at 8:04 am
Viewing 15 posts - 1,666 through 1,680 (of 2,647 total)