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 ?

  • maida_rh (1/31/2013)


    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'

    How you are restoring ? through backup ?

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)