To answer some of your questions

1. Yes the old database is up and No I didn't run the migration tool on it...I am not familiar with it.

2. I am not...

After writing my post I found a good article that explained what a "Schema" is and how it is used in 2005. Apparently all the other big db environments...

Hey Andy,

Thanks for the reference...

Leeland

Hey Lynn that script is very nice...where did you come up with that?

Lynn Beat me too it...from what I understand I can change the Collation on the DB...but it will not fix the current table collations...it will fix any "New" tables that...

It is actually two seperate databases I am working on...and the first one is only 8 tables (no biggy)...however the second database has like 100+ tables (WAY TOO MANY)...

So I...

OK I got it to work...but this is really going to stink if I have to do this for each table in the database

I was originally doing something like this

SET...

Hey Steve Thanks for the code...works like a charm.  I altered it a small bit to account for both service accounts and also listing one backup device...

SET NOCOUNT ON

DECLARE @SQLService...

I didn't think so...I could not find anything about it anywhere...

I kind of noticed the same thing as you described, even though I have 6 tasks going to the same connection, and the option to set the number of connections...

OK that makes sense...

The reason I brought this topic up is I have to move 6 tables from one database to another on separate servers daily. The current process...

Would it be to just check sp_who2 when you have the issue to check for blocking...ect.

If it were the code, could a begin tran with no commit be a cause...

Worked like a charm...

I was inside the box and didn't see the whole picture...I guess if I would have staired at it long enough I would have realized I could...

OK maybe I am looking at this wrong...I have the entire package connected except this one task.  If I right-click and disable that single task and use the code to...

You were right...I think.  The task ran by itself would just display the SQL tasks description...and nothing else.  What I did to get it to work is embed the code...