Viewing 15 posts - 3,841 through 3,855 (of 5,685 total)
Mike Hinds (3/3/2011)
There is a Service Broker - and here I turn ignorant. I don't know how to access or examine it, i.e. to verify the source queue.
Alright, there's a...
March 3, 2011 at 11:45 am
kladna (3/2/2011)
March 2, 2011 at 8:39 pm
Mike Hinds (3/2/2011)
(No column name)(No column name)usedtotalqueue_messages_846626059339836631990103199419sysdercv6796973484825484888
sysdesend67969734883648856
sysconvgroup67969733140131408
sysobjvalues2596186
What are they, and what can I safely do with them?
:blink: Do you have Service Broker active on this database? Check to see...
March 2, 2011 at 1:46 pm
Ninja's_RGR'us (3/2/2011)
The only real...
March 2, 2011 at 1:29 pm
*facepalm*
I'd assumed the code worked before the whole namechange malfunction previously. Welp, that would certainly do it! Glad you figured it out.
March 2, 2011 at 12:25 pm
Yeah Ninja, I fear you're right, we're missing something obvious and just not asking the right questions.
NewBee... can you do the following for me? I want to see what...
March 2, 2011 at 12:09 pm
Just curious, have you tried stopping and restarting the SQL Server Service, and/or rebooting the server? Smells like a glitch, so I'd start with doing standard glitch recovery protocols....
March 2, 2011 at 11:13 am
Stefan Krzywicki (3/2/2011)
jcrawf02 (3/2/2011)
Jan Van der Eecken (3/2/2011)
Now we know why there is no longer a rain forest in Spain 😉
No, that's because (all together now) the rain in Spain...
March 2, 2011 at 10:46 am
I will agree with sturner that that multiple server brokering is much more complex, but worthwhile in the end. I find the Service Broker tool to be rather robust.
What...
March 2, 2011 at 10:41 am
GSquared (3/2/2011)
amenjonathan (3/2/2011)
March 2, 2011 at 10:36 am
dndaughtery (3/2/2011)
March 2, 2011 at 10:25 am
Rob Reid-246754 (3/2/2011)
Therefore in your opinion what would be the best way to achieve the UPDATE of multiple rows without resorting to a CURSOR/WHILE loop which I...
March 2, 2011 at 10:19 am
rafa.aborges (3/1/2011)
Also, if I try to connect through "osql" I got the same error (Data source name not found and no default driver specified).
:crazy: There goes my theory on...
March 1, 2011 at 8:55 pm
rafa.aborges (3/1/2011)
Craig Farrell (3/1/2011)
From here: http://social.msdn.microsoft.com/Forums/en/sqlgetstarted/thread/73327808-c24d-4b01-be70-840c15c9ff3aIs this a virtual server? You might need to doublecheck the registry.
Thanks for the reply, but I already tried this and it didn't work...
March 1, 2011 at 7:18 pm
From here: http://social.msdn.microsoft.com/Forums/en/sqlgetstarted/thread/73327808-c24d-4b01-be70-840c15c9ff3a
Is this a virtual server? You might need to doublecheck the registry.
March 1, 2011 at 6:11 pm
Viewing 15 posts - 3,841 through 3,855 (of 5,685 total)