Click here to monitor SSC
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 | 543 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,251 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,043 reads
   Items 1 to 3 of 3