Click here to Skip to main content
15,919,879 members
Home / Discussions / System Admin
   

System Admin

 
GeneralRe: Secret Folder in Vista? Pin
Luc Pattyn2-Feb-09 14:38
sitebuilderLuc Pattyn2-Feb-09 14:38 
GeneralRe: Secret Folder in Vista? Pin
OldDog.Net3-Feb-09 2:44
OldDog.Net3-Feb-09 2:44 
GeneralRe: Secret Folder in Vista? Pin
Luc Pattyn3-Feb-09 3:13
sitebuilderLuc Pattyn3-Feb-09 3:13 
QuestionWhat are the different between users,Roles and schemas? Pin
bintaleb14031-Feb-09 22:29
bintaleb14031-Feb-09 22:29 
AnswerRe: What are the different between users,Roles and schemas? Pin
Wendelius15-Feb-09 6:15
mentorWendelius15-Feb-09 6:15 
GeneralRe: What are the different between users,Roles and schemas? Pin
bintaleb140316-Feb-09 17:58
bintaleb140316-Feb-09 17:58 
GeneralRe: What are the different between users,Roles and schemas? Pin
Wendelius17-Feb-09 7:22
mentorWendelius17-Feb-09 7:22 
AnswerRe: What are the different between users,Roles and schemas? Pin
Sunil Dass26-Mar-09 7:58
Sunil Dass26-Mar-09 7:58 
I hope this help also.

SQL Server 2005 introduces schemas to the database. A schema is simply a named container for database objects. Each schema is a scope that fits into the hierarchy between database level and object level, and each schema has a specific owner. The owner of a schema can be a user, a database role, or an application role. The schema name takes the place of the owner name in the SQL Server multi-part object naming scheme.

Schemas solve an administration problem that occurs when each database object is named after the user who creates it. In SQL Server versions prior to 2005, if a user named Bob (who is not dbo) creates a series of tables, the tables would be named after Bob. If Bob leaves the company or changes job assignments, these tables would have to be manually transferred to another user. If this transfer were not performed, a security problem could ensue.
QuestionA Backup/Restore Question Pin
Roger Wright27-Jan-09 3:50
professionalRoger Wright27-Jan-09 3:50 
QuestionRe: A Backup/Restore Question Pin
Jörgen Andersson27-Jan-09 5:32
professionalJörgen Andersson27-Jan-09 5:32 
AnswerRe: A Backup/Restore Question Pin
Roger Wright27-Jan-09 5:55
professionalRoger Wright27-Jan-09 5:55 
GeneralRe: A Backup/Restore Question Pin
Jörgen Andersson27-Jan-09 22:06
professionalJörgen Andersson27-Jan-09 22:06 
GeneralRe: A Backup/Restore Question Pin
Roger Wright28-Jan-09 1:57
professionalRoger Wright28-Jan-09 1:57 
GeneralRe: A Backup/Restore Question Pin
Jörgen Andersson28-Jan-09 2:09
professionalJörgen Andersson28-Jan-09 2:09 
AnswerRe: A Backup/Restore Question Pin
El Corazon9-Feb-09 6:16
El Corazon9-Feb-09 6:16 
QuestionNeed exchange 5.5 trail Pin
Mekong River25-Jan-09 20:47
Mekong River25-Jan-09 20:47 
AnswerRe: Need exchange 5.5 trail Pin
Jörgen Andersson25-Jan-09 21:03
professionalJörgen Andersson25-Jan-09 21:03 
GeneralRe: Need exchange 5.5 trail Pin
Mekong River25-Jan-09 21:07
Mekong River25-Jan-09 21:07 
GeneralRe: Need exchange 5.5 trail Pin
Jörgen Andersson25-Jan-09 21:08
professionalJörgen Andersson25-Jan-09 21:08 
GeneralRe: Need exchange 5.5 trail Pin
Mekong River25-Jan-09 22:50
Mekong River25-Jan-09 22:50 
GeneralRe: Need exchange 5.5 trail Pin
Jörgen Andersson26-Jan-09 22:54
professionalJörgen Andersson26-Jan-09 22:54 
GeneralRe: Need exchange 5.5 trail Pin
Mekong River26-Jan-09 22:56
Mekong River26-Jan-09 22:56 
GeneralRe: Need exchange 5.5 trail Pin
Jörgen Andersson26-Jan-09 23:08
professionalJörgen Andersson26-Jan-09 23:08 
GeneralRe: Need exchange 5.5 trail Pin
Mekong River26-Jan-09 23:15
Mekong River26-Jan-09 23:15 
GeneralRe: Need exchange 5.5 trail Pin
Dave Kreskowiak26-Jan-09 16:19
mveDave Kreskowiak26-Jan-09 16:19 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.