Also I would suggest to run DNSFlush.

Please make sure before you uninstall SQL 2005- If you moved over all the logins and database users,CLR assemblies, jobs, DTS/ SSIS packages, Linked servers, Replication, Mirroring, log shipping.

According to the error your posted, there should be another error in the log before this error. Can you post that error as well?

Can you post an exact error, if possible the screen shot?

Finally someone replied.Thanks a lot for your help. I thought so too, but just wanted to confirm. Really appreciate your response.

Please give us more details and screen shots if possible.

SSRS Version?

Service pack?

Can anyone help me? I would really appreciate it.

Check this out

http://technet.microsoft.com/en-us/library/cc966540.aspx

Here are the scripts to create scenario

--Create Snapshot

CREATE DATABASE AdventureWorksSnap08052010 ON

( NAME = AdventureWorks_Data, FILENAME =

'E:\MSSQL\Data\AdventureWorksSnap08052010.ss' )

AS SNAPSHOT OF AdventureWorks;

GO

select * from HumanResources.Employee

select * from AdventureWorksSnap08052010.HumanResources.Employee

Update HumanResources.Employee Set HireDate='1996-07-30'...

Yes, did not find an entry for Snapshot restore.

Can't believe this, no one answered as yet.

Does anyone know about it? I am still not able to figure it out. Any help is appreciated.

Check this link from one of my favorite Bloggers-Muthusamy Anantha Kumar aka The MAK

http://www.databasejournal.com/features/mssql/article.php/3647561/Data-partitioning-in-SQL-Server-2005---Part-V.htm

Does it have clustered index on it?

Can you translate the error message in English?