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

Scripts by Teshome Asfaw

SQLServerCentral.com profile

   Items 1 to 2 of 2   
 

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 2013/09/04 | Source: SQLServerCentral.com | Category: ddl trigger
Rating: |  Discuss |   Briefcase | 600 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 | 995 reads
   Items 1 to 2 of 2