Viewing 15 posts - 3,076 through 3,090 (of 5,678 total)
Well, if we're goin' oldskool... 🙂
Note how at the beginning of this script I made the data easily consumable and testable. It's a shortened list but if you want...
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
June 1, 2011 at 2:36 pm
What you want is most likely transactional or snapshot replication, depending on if you want it real time or scheduled.
Intro: http://msdn.microsoft.com/en-us/library/ms151198.aspx
Deployment walkthrough (longish, multiple links): http://msdn.microsoft.com/en-us/library/bb677158.aspx
That should get you started.
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
June 1, 2011 at 2:21 pm
james.morrison 19355 (6/1/2011)
itpcpro (5/26/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
June 1, 2011 at 2:18 pm
SQL Guy 1 (6/1/2011)
But what the difference it makes for you how you call yourself Junoir, Senior.
If you don't mind a little self-promotion...
http://www.sqlservercentral.com/articles/Career/71608/
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
June 1, 2011 at 2:15 pm
To help you find the change that Lowell did to make your code work, you've done a little too much VB.NET. 🙂
SQL uses + where VB.NET uses & (well, and...
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
June 1, 2011 at 1:48 pm
Lowell (6/1/2011)
if not too much time has past, the default trace, which logs DDL events like CREATE ALTER DROP, might still have it:
Good call, Lowell, I forgot about the rolling...
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
June 1, 2011 at 1:39 pm
dtexec.exe
You'll need to run it from a command line opened from the VB, set your necessary parameters, etc.
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
June 1, 2011 at 1:33 pm
The Dixie Flatline (6/1/2011)
GilaMonster (6/1/2011)
DBCC RunLikeHellDBCC MyEyesMyEyesIveGoneBlind
Waitasecondheeeeerrrreeee....
You're good with him Nekkid, but the Speedo's a problem?
Hmmmm... I smells a rat.
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
June 1, 2011 at 1:13 pm
There won't be unless you have certain traces or auditing types on, or server/database event triggers.
You won't be able to track this back, not 'officially'.
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
June 1, 2011 at 1:11 pm
Kevin Skinner (6/1/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
June 1, 2011 at 1:01 pm
You won't get there in SSIS components alone.
You'll either need to feed it down to a SQL query, use XQuery, and then reform it or you'll need to pass it...
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
June 1, 2011 at 12:56 pm
SQLRNNR (6/1/2011)
The Dixie Flatline (6/1/2011)
May have to shut it for quite a long time too 😉
However long it takes.
Your running rhino icon looks naked, Jason.
Would...
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
June 1, 2011 at 12:53 pm
Perhaps it was, but your test data is from April and your results are for March, thus, they don't directly match, so we don't know when we've arrived at the...
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
June 1, 2011 at 12:10 pm
mister.magoo (5/31/2011)
agustingarzon (5/31/2011)
What do you mean with un-3part named tables ? All the tables are in the...
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
May 31, 2011 at 5:38 pm
Jeff Moden (5/31/2011)
The Dixie Flatline (5/31/2011)
Could 42 possibly be the airspeed velocity of an unladen swallow?Nope... it's the terminal velocity for a pork chop with a bone in it. 😀
Is...
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
May 31, 2011 at 4:44 pm
Viewing 15 posts - 3,076 through 3,090 (of 5,678 total)