the problem is the permissions are removed when attaching a database to an other server.

Muhammad

OK, thanks a lot Karl

Do you know what is happen internally in the server when a user attaches a database, i.e. is there any procedures called or any thing else?

Muhammad

I'm sorry Karl,

I feel that i buzzard you,

What i need is to prevent a user from attaching a database until he/she provide a user name and a password.

when i attach the database file .mdf to another server and that database was secured the security removed, by secured i mean it has permissions.

the problem is:

when attach a secured database to another server the...