Post reply

Hi

  • February 6, 2006 at 2:24 pm

    #166837

    How to transfer as role and associated permission to a different server?

    I have tried 'Generate script but i wont give you the permission associated with differnt database objects.

    Any body have any customised script for this purpose??

     

    Any help would be appreciated...

  • February 6, 2006 at 3:52 pm

    #619123

    Generate Sql Script does work.

    In Enterprise manager, Right click on the database you want.

    Select All Tasks --> Generate Sql Script.

    Immediatelly go to the Options Tab and select Script Object Level Permissions (select Script sql server logins also if you need to).

    Then go to the Formatting Tab, Uncheck the Generate the CREATE ..., and the Generate the DROP... checkboxes (We don't want to drop and recreate all the tables now that would be bad.).

    Now go to the General tab. Click the show all box. and check the objects you want the permissions for. Ie tables , views stored procedures and functions.

    Click Preview, Voila.

     

  • February 6, 2006 at 4:48 pm

    #619132

    Thanks a lot,its working, last time we didnt selected the objects.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply