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

-- Create the maintenance schema

Post a comment or leave a trackback: Trackback URL.


Leave a Reply

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

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

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s

%d bloggers like this: