| jose's profileSQL Server 2005 blogsBlogLists |  Tools  Help |
|
January 11 SQL Server 2005 SchemasSQL Server 2005 Schemas
Schemas are used to organize database objects into namespaces. In the new SQL server 2005 security architecture, schemas are securable that contains database objects. A user can be granted access to a schema thereby allowing him to inherit the permissions on database objects inside the schema except for objects where he is explicitly denied.
When a SQL server user is created he can be assigned a default schema. If no default schema is assigned the user is assigned “DBO schema” as its default schema. When a user is assigned a default schema all unqualified data base objects are resolved first to his default schema. When an object is not found in the default schema it then falls back to the “DBO schema”. If the object in question is still not found in the “DBO schema “, an exemption is thrown Unlike sql server 2000, schemas are no longer tied to SQL server user which is now better known as the “Users-Schemas separation”. A schema can exist by itself and that means a user can be dropped without dropping the schema January 06 Keeping Things OrganizedKeeping Things Organized with
SQL Server 2005 Management Studio Solutions One of the new enhancements of the SQL Server Management Studio is the ability to keep things organized into a solution or a project. Equipped with the solution explorer, very similar to Microsoft Visual Studio it allows you easily navigate through your project. It makes life of DA and DBAs easier by providing the following features:
1. Save connection information with each script. 2. Maintain version control on scripts. 3. Store results options with scripts. 4. Organize related scripts into a single script project. Something to try:
1. Open SQL Server 2005 Management Studio
2. In the connect to Server dialog click “Cancel” 3. Click on file > new > create project 4. In the new project dialog click on “SQL Server Scripts” 5. In the name field of the new project dialog type “my adventure at work” 6. Click ok to create the project 7. In the solution explorer, Right click connection and click on new connection 8. Create a connection to your server but entering necessary data to the connect to server dialog. 9. A new connection appears in the connections folder of the solution explorer 10. Right click the newly create connection and click on new query 11. Type the following scripts:
12. run and save the scripts 13. close and reopen the project |
|
|
