Home Forums SQL Server 2008 SQL Server 2008 - General Why I need to assign Grant/Deny Permission after every database restore ? RE: Why I need to assign Grant/Deny Permission after every database restore ?

  • I am using sql server authentication and user i assigned permission also have login id and pass,I googled the term "orphan login and got this :

    what do i need to do as i need the restore to commit the change to a single table structure + data .

    I tryed the import but got error:

    Violation of primary key constraints 'userid' .can not insert duplicate key in object 'usertb'

    Kindly let me know and thanks