Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

User Defined Server Roles Expand / Collapse
Author
Message
Posted Thursday, August 8, 2013 8:18 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 5:53 PM
Points: 33,063, Visits: 15,179
Comments posted to this topic are about the item User Defined Server Roles






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1482623
Posted Thursday, August 8, 2013 11:55 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 6:29 AM
Points: 13,273, Visits: 10,150
Easy one to finish the week, thanks Steve!



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1482642
Posted Friday, August 9, 2013 1:36 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 7:37 PM
Points: 21,215, Visits: 14,917
Koen Verbeeck (8/8/2013)
Easy one to finish the week, thanks Steve!


+1




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1482672
Posted Friday, August 9, 2013 6:22 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 6:16 AM
Points: 2,006, Visits: 2,004
User defined server roles looks interesting. Thanks for the question Steve.

A minor correction is needed on the reference. It points to fixed server-level roles not user defined and includes earlier versions of SQL Server.

The correct documentation should be: http://technet.microsoft.com/en-us/library/ee677610.aspx

Interestingly, I could not find a reference for 2014 so the correct answer may be 2012 instead of 2012 and above. More likely though is that the 2014 documentation isn't complete yet.

Enjoy!

Edit: It took a little longer but here's the reference for 2014 and 2012.
http://msdn.microsoft.com/en-us/library/ee677610(v=sql.120).aspx
Post #1482738
Posted Friday, August 9, 2013 7:18 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, July 25, 2014 8:34 AM
Points: 1,827, Visits: 1,361
Thanks for the easy one Steve!



Everything is awesome!
Post #1482761
Posted Friday, August 9, 2013 9:39 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, July 25, 2014 7:01 AM
Points: 1,761, Visits: 2,137
TGIF! Thanks for the question. Wouldn't mind more on user/role management.

Please don't go. The drones need you. They look up to you.
Connect to me on LinkedIn
Post #1482826
Posted Friday, August 9, 2013 9:50 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 5:53 PM
Points: 33,063, Visits: 15,179
Dave62 (8/9/2013)
User defined server roles looks interesting. Thanks for the question Steve.

A minor correction is needed on the reference. It points to fixed server-level roles not user defined and includes earlier versions of SQL Server.

The correct documentation should be: http://technet.microsoft.com/en-us/library/ee677610.aspx

Interestingly, I could not find a reference for 2014 so the correct answer may be 2012 instead of 2012 and above. More likely though is that the 2014 documentation isn't complete yet.

Enjoy!

Edit: It took a little longer but here's the reference for 2014 and 2012.
http://msdn.microsoft.com/en-us/library/ee677610(v=sql.120).aspx


Thanks for the link. I've updated the explanation.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1482840
Posted Friday, August 9, 2013 10:15 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, July 18, 2014 11:41 AM
Points: 309, Visits: 279
Good easy question on new TSQL functionality... Thanks Steve!
Post #1482851
Posted Tuesday, August 20, 2013 2:02 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, July 21, 2014 6:24 AM
Points: 3,537, Visits: 2,647
Nice easy question. Keen to check this functionality out in SQL 2012.
Post #1486136
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse