Tip of the Day : Fixed Server Roles

Welcome to SQL Server Helper !!!

This site is intended for those who are beginning to use SQL Server as part of their day-to-day activities.  You will find in this site a collection of useful functions, triggers, stored procedures and tips and tricks related to SQL Server.

Should you have any comments or questions regarding this site or if you want to ask SQL Server-related questions, e-mail us here.

We hope we are able to help and we are glad to help!!!

SQL Server Tip of the Day - July 21, 2017

Fixed Server Roles

Fixed server roles are defined at the server level and have specific server-level administrative activities. They are server-wide in their scope and cannot be added, removed, or changed. Each member of a fixed server role can add other logins to that same role.

Fixed Server Role Description Server-Level Permission
bulkadmin Members of the bulkadmin fixed server role can run the BULK INSERT statement. ADMINISTER BULK OPERATIONS
dbcreator Members of the dbcreator fixed server role can create, alter, drop and restore any database. CREATE DATABASE
diskadmin Members of the diskadmin fixed server role can manage disk files. ALTER RESOURCES
processadmin Members of the processadmin fixed server role can terminate processes that are running in any instance of SQL Server. ALTER ANY CONNECTION
securityadmin Members of the securityadmin fixed server role can manage logins and their properties. They can GRANT, DENY and REVOKE server-level permission. They can also GRANT, DENY and REVOKE database-level permissions. Additionally, they can reset password for SQL Server logins. ALTER ANY LOGIN
serveradmin Members of the serveradmin fixed server role can change server-wide configuration options and shut down the server. ALTER ANY ENDPOINT
setupadmin Members of the setupadmin fixed server role can add and remove linked servers, and also execute some system stored procedures. ALTER ANY LINKED SERVER
sysadmin Members of the sysadmin fixed server role can perform any activity in the server. CONTROL SERVER

SQL Server 2012

SQL Server 2008

User-Defined Functions

Date Functions

A collection of useful user-defined functions that deal with dates.

String Functions

A collection of useful user-defined functions that deal with strings (varchar/char/nvarchar/nchar).

Tree Functions

A collection of useful user-defined functions that deal with tree or hierarchical design structures.

Table-Valued Functions

A collection of useful table-valued user-defined functions that can be used to join with other tables.

SQL Server Built-in Functions

A reference to all built-in functions available within SQL Server grouped into categories.

Tips and Tricks

A collection of useful SQL Server-related tips and tricks:

SQL Server Error Messages

A list of SQL Server error messages and for certain error messages, discusses ways on how to solve the error or work around them:

Frequently Asked Questions