Have you tried doing a backup and restore? That many times can be easier. When trying to move an entire database I get into problems with relationships.
Do you have logins in the Server database server that have not been created in the XP database server? Also, if you have users in the database, do they link up to the logins in the server. I look in the "user" section for your database. Every user in that list (except perhaps dbo and guest) should have a login listed. If not, then you need to create a link from the login to the user in the database.
Russel Loski, MCSE Business Intelligence, Data Platform