Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 User permision

Author  Topic 

rohitmathur11
Yak Posting Veteran

77 Posts

Posted - 2010-01-20 : 04:09:09
Hi,

How to give permision to a login to insert data in to another database which is on onther server ..

like on server A i m have one login ABC ...

this ABC need to insert data in to database which is on server B

how can give permision ...

any idea...?

Kristen
Test

22859 Posts

Posted - 2010-01-20 : 05:33:31
Create a linked server, as I explained in your other question:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=138590
Go to Top of Page
   

- Advertisement -