Viewing 13 posts - 16 through 28 (of 28 total)
I ended up re-installing the instance. Works fine now. Thanks though gents!
August 13, 2014 at 8:12 am
I installed SQL Server 2008 R2 SP1 through windows update.
August 12, 2014 at 12:39 pm
Did you try it from the destination server? As mentioned above, this is probably related to using older management server software to perform the copy. Try it from the 2012...
January 21, 2014 at 6:33 am
I like it; it's alot cleaner. The original was starting to cause me to skim and delete because there was just too much. I like how everything is basically one...
August 6, 2013 at 12:23 pm
Joe, thanks for that insight. I bet that's what going on. I have both SMO 2008 R2 and SMO 2012 installed on my workstation. I can't remember exactly which one...
April 8, 2013 at 6:25 am
SMO; I want to allow the database to remain online.
I can't finish the wizard to actually create the package; I get the error on the last step.
February 7, 2013 at 7:24 am
Did you ever find a solution to this? I'm having the same problem, connecting to a SQL 2005.
February 6, 2013 at 11:26 am
Ah, thanks! I tried that and those two extra results disappeared. It makes sense that they are dumped into that variable. Thanks for providing the example!
November 28, 2012 at 7:08 am
Thanks, that was what I was wondering. I didn't know if it meant something important, like "these are the two wait states that are causing the biggest problem" or something....
November 28, 2012 at 6:52 am
I'm trying to understand the first two sets of results and where they come from in the code. You'll notice I get three result sets back, where do the first...
November 27, 2012 at 8:28 am
With virtual learning it would seem we could make this happen. I would devote an hour a day to get online with colleagues, spend 15-30 mins having an instructor explain...
July 7, 2011 at 6:29 am
I was really happy to see this post. As a DBA I live in constant fear that I'm going to get the call that a mission critical application is down...
March 28, 2011 at 6:06 am
Thank you both for the reply! I'll see how the loginID(UserID) is stored, maybe it's somewhere in the ASP application, and see if I can use that to pass some...
January 25, 2011 at 5:50 am