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: Today @ 6:07 PM
Points: 31,284, Visits: 15,744
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 @ 2:35 PM
Points: 13,532, Visits: 11,328
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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 5:56 PM
Points: 17,958, Visits: 15,956
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, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1482672
Posted Friday, August 9, 2013 6:22 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 9:35 AM
Points: 2,146, Visits: 2,150
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, November 21, 2014 1:23 PM
Points: 1,951, Visits: 1,473
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: Today @ 10:03 AM
Points: 1,895, Visits: 2,194
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: Today @ 6:07 PM
Points: 31,284, Visits: 15,744
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, November 14, 2014 10:55 AM
Points: 346, Visits: 310
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: Thursday, November 20, 2014 4:29 AM
Points: 3,559, Visits: 2,671
Nice easy question. Keen to check this functionality out in SQL 2012.
Post #1486136
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse