I ended up re-installing the instance. Works fine now. Thanks though gents!

I installed SQL Server 2008 R2 SP1 through windows update.

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...

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...

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...

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.

Thanks

Nick

Did you ever find a solution to this? I'm having the same problem, connecting to a SQL 2005.

Tony Trus;

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!

Nick

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....

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...

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...

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...

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...