From BOL:

Did the user log off and...

You really don't need to cross post as either someone will know the answer or not. As noted answers should be made to the other thread found here

I don't believe it is possible as I believe both are only allowed to be subscribers. Meaning that I don't think 2000 can be a publisher to a 2005...

Here's a link to Kimberly Tripp's blog where she provides some links to SQL Server Virtualization resources (albiet for 2008, but may apply to 2005 as well):

http://www.sqlskills.com/BLOGS/KIMBERLY/post/Virtualization-with-SQL-Server.aspx

Check out this thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=3478943&SiteID=1

Andy Warren (11/14/2008)

---

Jack, I'd argue that time spent on SSC is productive, but it's not the 'real' work that I'd count towards my goal of 6.5 hours a day. As...

You really need 2 data flow tasks which each have their own flat file connections, one that loads the 37 column files and one that loads the 15 column files.

Okay, as I said in my previous post, you may need to tweak the code. So replace this:

If conn.Status <> Open Then

conn.Open

End If ...

I find it hard to quantify what is "productive". Is answering a question on SSC productive? The short-term answer is probably "No", but long-term I would say, "Yes"....

What do you mean by "doesn't seem to like it"?

You still need to instantiate the command object like you were doing, and then you add the code I supplied.

Try...

The Query processor applies filters on Where and JOin's at different times in the process. When you are doing INNER JOIN's you will probably be okay, but with OUTER...

I believe you just need to add a:

da.ExecuteNonQuery()

This executes the command and does not expect a resultset to be returned.

Chad Crawford (11/13/2008)

---

Check boxes mean that there are possibly more than 1 correct answer and you need to select all of them. It's no better or worse than Microsoft...

Ninja's_RGR'us (11/13/2008)

---

1 - Can the VM backups include the live DB files (I'm guessing no but I have no way to test it). This would mean that we could...

Sure it is possible, but then you need to use joins.