Viewing 15 posts - 3,076 through 3,090 (of 5,685 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...
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.
June 1, 2011 at 2:21 pm
james.morrison 19355 (6/1/2011)
itpcpro (5/26/2011)
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...
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...
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...
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.
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.
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'.
June 1, 2011 at 1:11 pm
Kevin Skinner (6/1/2011)
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...
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...
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...
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...
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...
May 31, 2011 at 4:44 pm
Viewing 15 posts - 3,076 through 3,090 (of 5,685 total)