we recentely migrated our database from 2000 to sql server 2005.The migrated database has some issues like collation issues,so we created the scripts for each databases and then updated these scripts to remove collation issues to make these compatible to SQL server 2005.
But we have some permission issues for the users in case of these created databases i.e. we are unable to see all the tables with ssupdate user id ,or any other id .except the dbo id
which is the owner of this database,where we can see all the tables and stored procedures.
iam fairly new at sql server .does anyone have any suugestions or critcisms ?
you are welcome.