I'm not sure I understand your question but it depends on your situation.

You have to perform some...

You will probably be better reinstalling as opposed to changing the instance name.

http://stackoverflow.com/questions/907851/change-sql-server-instance-name

http://social.msdn.microsoft.com/Forums/en/sqlgetstarted/thread/f7b1fae3-e5e1-4aa9-9285-68694e09a0a3

I have had that problem before.

I had to place breakpoints, step though the code and check the values.

To consolidate Servers is an exercise where you decommission Database Servers and move the databases to the consolidated Server.

You save on operating and licensing cost, etc.

It is a lot faster to detach/attach then it is to backup the Database.

I would still have cold backups before I do the move.

This should be in the SSIS Forum

I have only provided you with a very high level description of the process.

If you get the file via FTP you can use the...

I could only find one link:

http://social.msdn.microsoft.com/Forums/en/sqltools/thread/56f89203-4fa4-4f34-a9c8-1edb494fa33d

I'm sorry. I will not post again to this forum. Best regards to everyone.

Just forget it

I'm wondering about misuse of the forum.

ok, I will not participate in in this forum.

Well thank you so so much!

I'm sorry but but it appeared to to be a "special" new classification, for I have not seen it before?

I never saw that classification before...

I will take the hit..