Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Bacic steps of creating SQL Server database

Author  Topic 

Muzokh
Starting Member

21 Posts

Posted - 2011-11-30 : 18:44:04
Hi all
Can somebody explain me the basic steps of creating any database in
SQL Server 2008.

I am going to write some steps sequence wise, please suggest

- create database
- create new role
- create user
- create schema
- grant access

Please advice

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2011-11-30 : 20:42:34
by any chance you have the Books Online ?
How to: Create a Database (SQL Server Management Studio)
How to: Create, Delete, or Modify a Role (Management Studio)
How to: Create a SQL Server Login
How to: Create a Database Schema
Permissions (Database Engine)


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

Muzokh
Starting Member

21 Posts

Posted - 2011-12-01 : 07:29:20
Thanks for the links but my question is that what are the steps behind of creating a new database means what are the steps we need to consider in order to create any database like securities issues, login method,user creation,schemas and so on.
Go to Top of Page
   

- Advertisement -