Post reply

How can i rename a user role ?

  • June 9, 2008 at 10:18 am

    #129394

    Hello, i need your help to perform the change in the name of a user role. I am using sql server 2000, and dont know how to do it.

    Thanks in advance for your help

  • June 9, 2008 at 10:26 am

    #826194

    The only way I've been able to do it is to drop the role and recreate it.

    Greg

  • June 9, 2008 at 10:42 am

    #826202

    Thanks for your answer, you know how to copy all the users from the old role to the new role?

    Also, i need know how to list all the triggers from all the databases hosted in my server. All the sp that i look run only over the current db.

    Thanks in advance

  • June 9, 2008 at 4:10 pm

    #826386

    I think you'll have to either do them manually in Enterprise Manager or script them out of sysmembers in TSQL.

    Greg

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

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