SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Scripts by Teshome Asfaw

SQLServerCentral.com profile

   Items 1 to 3 of 3   

Instance wide script to add user (the 4th way)

The script can be used to perform any task against all databases hosted on an instance. This is an example script that checks if a user is in a database if it is not then create the user and add it db_datareader role.   Read more...
Rating: |  Discuss |   Briefcase | 569 reads

Add user with DDL Trigger

DDL trigger will add a user to a newly created database and assign db_owner role. It can be modified for what role is required.  Read more...
By Teshome Asfaw 2015/03/12 | Source: SQLServerCentral.com | Category: ddl trigger
Rating: |  Discuss |   Briefcase | 1,267 reads

Instance wide missing index

Database tables without primary key, clustered index and no index  Read more...
By Teshome Asfaw 2008/08/13 | Source: SQLServerCentral.com | Category: maintenance
Rating: |  Discuss |   Briefcase | 1,059 reads
   Items 1 to 3 of 3