How to check if role exists in SQL Server database

1149615 pts.
Tags:
SQL Server
SQL Server database
I need to add several users, in the same role, on multiple SQL Server databases. But that role can't be present too. How would I be able to check if an actual role exists in my database?
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • edwinjhoffer
    Try:
    SELECT DATABASE_PRINCIPAL_ID('role')
    3,740 pointsBadges:
    report
  • jharati
    Did you try sp_helprole 'role'?
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: