Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Content with tag Schemas Rss

   Items 1 to 20 of 26    Older >>

Creating schemas

By Steve Jones 2015/03/03 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,733 reads

Capture CREATE, DROP, ALTER from the default SQL trace file

Tracks and stores changes to database objects by reading from the default SQL server trace file using ::fn_trace_gettable()  Read more...
By MyDoggieJessie 2015/02/02 | Source: | Category: trace files
Rating: |  Discuss |   Briefcase | 4,449 reads

Stairway to SQL Server Security Level 5: Schemas and Security

In this stairway level you’ll learn how you can give principals access to groups of objects by assigning permissions on schemas instead of individual tables, code modules, and other objects. You’ll also learn about the benefits of user-schema separation and how it can increase object security, and how using default schemas for users and groups can simplify object access management and security.  Read more...
By Don Kiely 2014/12/03 | Source:
Rating: |  Discuss |   Briefcase | 3,947 reads

SQL Monitor Custom Metric: Schema Modified

This metric creates an alert that will be raised when something is added to the schema, or the existing schema is modified.  Read more...
By Press Release 2014/08/05 | Source: Redgate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 8,247 reads

Default schema

By Anoo S Pillai 2014/03/31 | Category: schemas
Rating: (not yet rated) |  Discuss |   Briefcase | 1,890 reads

Divide and Conquer

Schemas may be largely irrelevant to small databases, where it is no trouble to assign permissions to individual objects, but they are vital for a hard working corporate database that is being actively developed and used by several applications, with thousands of objects that must be assigned the correct permission.  Read more...
By Phil Factor 2014/03/24 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 112 reads

Schema & Renaming Fun

By Andy Warren 2014/03/12 | Category: schemas
Rating: (not yet rated) |  Discuss |   Briefcase | 1,818 reads

Auto dump out database schema

This powershell script will dump out a database schema to a text file.  Read more...
By Neil Bryan 2014/02/04 | Source: | Category: schemas
Rating: |  Discuss |   Briefcase | 1,479 reads

Find Foriegn Keys and their details in a database

Use this script to find all the Foriegn Keys and their details in a database  Read more...
By Bodhisatya Mookherjee 2013/09/11 | Source: | Category: schemas
Rating: |  Discuss |   Briefcase | 1,376 reads

Schema-Owned Tables and Generated DROP Scripts (SQL Spackle)

Not all SQL-generated scripts are created equal (or correctly) for alternative schema-owned objects.  Read more...
By Brandie Tarvin 2013/08/01 | Source: | Category: generate scripts
Rating: |  Discuss |   Briefcase | 3,216 reads

iSpy (on your development)

Using EventNotification (Service Broker - DDL_EVENTS) to audit Schema change on a Server, or any of it's databases  Read more...
By Rob Lobbe 2013/06/19 | Source: | Category: schemas
Rating: |  Discuss |   Briefcase | 1,380 reads

Which Statement will execute sucessfully

By malls reddy 2012/12/07 | Category: schemas
Rating: (not yet rated) |  Discuss |   Briefcase | 2,100 reads

List of objects from particular schemas

This helps to get list of all objects in a particular schemas.  Read more...
By Nitesh R Dedhia 2012/08/13 | Source: | Category: schemas
Rating: |  Discuss |   Briefcase | 1,036 reads

Copy One Schema to Another Schema

This script copies one object in another multiple schema.  Read more...
By Vinay Kumar 2011/08/31 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,212 reads

Going From Many Schemas To One Schema

A Technique to deal with moving data from multiple schemas into one table  Read more...
By Timothy A Wiseman 2010/08/09 | Source: | Category: etl
Rating: |  Discuss |   Briefcase | 6,312 reads

default schema trouble

By Nils Gustav Stråbø 2010/07/28 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 3,155 reads

The Schema Debate

There was quite a bit of debate over the use of schemas recently on the Internet. Steve Jones talks about some of the reasons why you might want a schema, and a few reasons why you might not.  Read more...
By Steve Jones 2010/06/22 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 575 reads

Breaking ownership chaining within a schema in SQL Server

I have several objects, all in the same schema. Because of this, ownership chaining is working, as described in this previous tip. However, I don't want ownership chaining to be on, but I need the objects to remain in the same schema. How can I do this?  Read more...
By Additional Articles 2009/08/21 | Source: | Category: security
Rating: (not yet rated)  Rate this |   Briefcase | 2,817 reads

Granting limited permissions to create views in another schema in SQL Server - Part 2

In a previous tip, Granting limited permissions to create views in another schema in SQL Server, I showed how to use the CREATE VIEW permission and the ALTER SCHEMA permission to allow users to create new views using the same schema as the tables. However, I have found that the users can alter and drop tables in this schema which is beyond what I want them to do. A DENY CREATE TABLE does not work, so what can I do to prevent them from touching the tables in this way? In this tip I will show you how you can use a DDL trigger to prevent this unneeded access.  Read more...
By Additional Articles 2009/08/17 | Source: | Category: schemas
Rating: (not yet rated)  Rate this |   Briefcase | 2,893 reads

SQL Server Best Practices - Implementation of Database Object Schemas

SQL Server 2005 implemented the concept of a database object schema. A schema is a distinct namespace to facilitate the separation, management, and ownership of database objects. It removed the tight coupling of database objects and owners to improve the security administration of database objects. Database object schemas offer functionality to control and help secure application objects within a database environment not available in previous versions of SQL Server.  Read more...
By Additional Articles 2009/07/17 | Source: TechNet Blogs | Category: sql server 2008
Rating:  Rate this |   Briefcase | 3,740 reads
   Items 1 to 20 of 26    Older >>
t-sql (6)    
security (5)    
ddl triggers (2)    
editorial (2)    
sql server 2008 (2)    
administration (1)    
auditing (1)    
black box (1)    
blogs (1)    
custom metrics (1)    
database design (1)    
database weekly (1)    
ddl_events (1)    
dependencies (1)    
development (1)    
drop constraint (1)    
etl (1)    
eventnotification (1)    
events (1)    
foreign keys (1)    
generate scripts (1)    
information_schema (1)    
list of objects (1)    
notifications (1)    
ownership chaining (1)    
powershell (1)    
quotename (1)    
recursive function (1)    
recycle bin (1)    
rename (1)    
server security (1)    
sql monitor (1)    
sql server 2005 (1)    
sql server 2008 r2 (1)    
stairway series (1)    
trace files (1)    
user defined function (udf) (1)