Maintenance Schema

As the first post in the “maintenance” section, why not start with an easy one: creation of a maintenance schema. Using a schema to group maintenance tasks allows you to easily assign elevated privileges to them via the controlling user(s) as well as simply ensuring they are displayed with like-purposed entities within SQL Server Management Studio (SSMS).

The basic syntax is simple: specify the database within which you would like to create the schema, then create the schema with the default owner. For this example, we will use a database named “DB” and assign the database owner “dbo” user as the owner.

-- Specify the database to use
USE [DB];
GO

-- Create the maintenance schema
CREATE SCHEMA [mx] AUTHORIZATION [dbo];
GO

Advertisements
Post a comment or leave a trackback: Trackback URL.

Comments

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: