here jack is not in my database. My problem here is i want to give access to jack on my server so that he can copy a backup of his database into my server. He is an user of another database.
It seems to me as though you first need to grant "Jack" access to your server - CREATE LOGIN or sp_addlogin are your friends here.
Once he's a valid user on the server, then you can give him the permissions he needs...
http://technet.microsoft.com/en-us/library/ms189751.aspx for more information on "CREATE LOGIN" command.
answered Jun 04, 2010 at 05:33 AM