T-SQL - Create Server Role Addrolemember dbcreater, bulkadmin to Role, Add Logins to ServerRole Created

Question

Viewing 6 posts - 1 through 6 (of 6 total)

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

Ant-Green SSC Guru Points: 113565 More actions · Answer 1

You cant create custom server roles unless you have SQL 2012.

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 2

Thanks.

When I execute the following statment from master:

EXEC sp_addrolemember N'dbcreator', N'jallen'

I get the following error:

Msg 15014, Level 16, State 1, Procedure sp_addrolemember, Line 36

The role 'dbcreator' does not exist in the current database.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Ant-Green SSC Guru Points: 113565 More actions · Answer 3

thats to add a user to a DB role, for a server role you need

sp_addsrvrolemember

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 4

That's right, forgot about that sp, thanks.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Ant-Green SSC Guru Points: 113565 More actions · Answer 5

not to worry, easy one that, especially for just three characters difference in the SP name