Never mind. Got it figured. Had to install it in the GAC.

That is not the reason it is failing. If it is the reason i wouldn't even able to validate the expression.

It is actually failing while running the package.

I have actually...

Thanks Greg.

you cant change it by rightclicking anything....

use have to use this SP

exec sp_changedbowner 'sa'

I have tried that....But as i said i am getting error. Do you have any idea why?? do i have to change any settings to be able to edit from...

Thanks Greg.

Can you explain how to fix the path after moving?

Is it by deleting the config files from package configurations and then adding them again by giving the correct the...

Where is the command dude?:D

FYI.

We cannot change the database owner by rightclicking the database and selecting properties.

We can change it by this command.

exec sp_changedbowner 'sa'

I would suggest you to go for side by side upgrade incase something happens its easy to revert back that way.

If everything goes well inplace is the easiest one.

Why dont...

DBCC SHRINKFILE (N'MSDBLog' , 500)

Ok you are doing Migration. It will be just like a normal migration but you will be having additional tasks like setting up MSDTC service.....Just go through the articles on...

you can restore the backup in a different box that is taken before the update. and then you can import that table from there.

The best way will be restore the backup in a different box that is taken before deletion of the data. And if you know the query that deleted the data...

Thanks David.

Can we actually change the named instance to a default instance using the fallowing code??

I cam accross this but not sure weather this works or not.

Exec sp_dropserver nameofinstance

Exec...

It is absolutely possible.

What type of upgrade you are planning??

In-place or side by side??