Viewing 15 posts - 4,756 through 4,770 (of 5,678 total)
Okay. Before I lead you down the wrong road, Service Broker stopping with that message can also happen due to a number of other causes, from MSDTC going wonky...
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
December 2, 2010 at 12:34 pm
LutzM (12/2/2010)
You'd basically use a script component after your data import to...
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
December 2, 2010 at 12:29 pm
samartel (12/2/2010)
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
December 2, 2010 at 12:27 pm
SQLNW (12/2/2010)
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
December 2, 2010 at 12:24 pm
Whoa, who's turning it off?
Implications: You've got an existing database(s) using service broker. These are feeding queues. Either the data on this server is going to become 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
December 2, 2010 at 12:01 pm
Logging - That orange tree really needs to come down....
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
December 2, 2010 at 11:58 am
You need to do something like this:
SELECT T.Col1, T.Col2, V.Col1, V.Col2, H.Col1, H.Col2
FROM Thundercats.dbo.Characters AS T
JOIN Voltron.dbo.Characters AS V
ON T.Name = V.Name
JOIN HeMan.dbo.Characters AS H
ON V.Name = H.Name
That will remove...
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
December 2, 2010 at 11:54 am
johnzabroski (12/2/2010)
The next comment (by RLF) in that thread clearly states a Windows Group cannot own a job, which matches the documentation in [1] and [2] referenced above. Then...
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
December 2, 2010 at 11:25 am
Nadrek (12/2/2010)
Name functions with accuracy and specificity!
This is similar to Age calculation functions: Age(birthdate, asofdate) is a bad name for calculating...
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
December 2, 2010 at 11:12 am
johnzabroski (12/2/2010)
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
December 2, 2010 at 10:57 am
Okay, the primary issue here is the error that states the instance can't find the target log shipping server, or at the least, doesn't have permissions anymore on the target...
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
December 2, 2010 at 10:33 am
abhijeet.send2me (12/2/2010)
I have the understanding about the logical files. I just wanted to find out if there is a way to increase them or not. or may...
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
December 2, 2010 at 10:28 am
Prakash Heda (12/1/2010)
2010-12-01 14:30:30.44*** Error: Could not retrieve backup settings for primary ID '3222a279-f58c-4c6b-a51c-b3a30a300a9a'.(Microsoft.SqlServer.Management.LogShipping) ***
Is this the recipient, or the source, for a logshipped database?
2010-12-01 14:30:30.44*** Error: Failed to connect...
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
December 1, 2010 at 6:42 pm
A couple of things to note.
First, what's a Virtual Log file? It's a logical separation of the file internal to it. Read more here:
http://msdn.microsoft.com/en-us/library/aa933049(SQL.80).aspx
And a quick discussion of...
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
December 1, 2010 at 6:16 pm
CirquedeSQLeil (12/1/2010)
Craig Farrell (12/1/2010)
http://www.sqlservercentral.com/Forums/Topic1028937-149-1.aspx?Update=1
I don't have access to anything I can reinstall...
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
December 1, 2010 at 6:05 pm
Viewing 15 posts - 4,756 through 4,770 (of 5,678 total)