Viewing 15 posts - 3,841 through 3,855 (of 5,678 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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
March 3, 2011 at 11:45 am
kladna (3/2/2011)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
March 2, 2011 at 1:46 pm
Ninja's_RGR'us (3/2/2011)
The only real...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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....
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
March 2, 2011 at 10:41 am
GSquared (3/2/2011)
amenjonathan (3/2/2011)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
March 2, 2011 at 10:36 am
dndaughtery (3/2/2011)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
March 1, 2011 at 6:11 pm
Viewing 15 posts - 3,841 through 3,855 (of 5,678 total)