Fixing orphaned database users in SQL 2005 to 2012

admin Sql 18 Gennaio , 2016

fonte: http://blogs.lessthandot.com/index.php/datamgmt/dbprogramming/fixing-orphaned-database-users/ by Ted Krueger (onpnt) on December 13, 2011 in category Database Administration Database Programming Microsoft SQL ServerMicrosoft SQL Server Admin. Article views: 43,756 This will be my contribution to the T-SQL Tuesday Challenge that was originally created by Adam Machanic. This month, my good friend Allen White (Blog | Twitter) is hosting the challenge.
Read More »

How to Setup SQL Server 2008/2008R2 Maintenance Plan and Email Notifications

admin Sql 13 Ottobre , 2014

fonte: http://nideesh.wordpress.com/2012/10/24/how-to-setup-sql-server-20082008r2-maintenance-plan-and-email-notifications/ How to Setup SQL Server 2008/2008R2 Maintenance Plan and Email Notifications Most of the time we will have good installation and configuration for several systems but when we talk about maintenance and regular health check there should be a delay in talk and response. Database backup and maintenance should consider very important DBA should
Read More »