I m mentioning the below steps what i did
1. MSSQL 2008 installed
2. Took Backup of databases from MSSQL 2005 and restored it in MSSQL 2008.
3. then run the script of revlogin that i mentioned before.
4. logins created for users.
Problems i faced :-
1. the users to which i gave all access like sa they can access any database no problem with them.
2. but the users to which i gave limited permission on limited databases and tables..that account user are not able to access any database.
3. then i tried ti give the permission to that user which was exist in MSSQL 2005... but that is also giving error like that ''the user is already exist''
i think the process i followed was wrong... pls suggest me the solution.
Thanks & Regards,