Below is the error which I faced at one of my client while installing sql server 2005 64-bits during migration from sql server 2005 32-bits on the same machine. Error: COM+ error while installing SQL Server 2005 64-bits during migration from SQL Server 2005 32-bits on the same machine. Issue Reported: While installing sql server 64-bits …

Continue reading COM+ error while installing sql server 2005 64-bits during migration from sql server 2005 32-bits on the same machine

Note:  Best viewed in Internet Explorer 6 and above Implementation: How to send login expiration notification alerts in SQL Server. Scenario: SQL Server login policies are same as the windows login policies.Its inherit the property from windows login/password policies. Now our target is to send mail notification before SQL Server login password get expired on production environment …

Continue reading Send login expiration notification alerts in sql server

Note:  Best viewed in Internet Explorer 6 and above Implementation: How to get SQL Server deadlock graph instantly on mail when deadlock occurs. Scenario:Lets say,there is one site where you have been deployed and you face deadlock on SQL server mostly.Now you want  to receive mail immediately with complete deadlock graph when SQL Server deadlock occurs. Infrastructure: Below …

Continue reading Get SQL Server deadlock graph instantly on mail when it occurs

Note:  Best viewed in Internet Explorer 6 and above Implementation:Sending mail alerts on SQL blocking queries details when particular query blocks other query by more than a defined time let say 2,3.. minutes. Scenario:Lets say,there is one site where you have been deployed and you face blocking on SQL server all the time.Now your TL want …

Continue reading How to send mail notification when SQL blocking occurs more than a defined time

Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Implementation: Sending html format mail to recipients of 'sp_readerrorlog' in sql server. Scenario:Lets say,Client wants to get the output of 'sp_readerrorlog' on mail with proper html …

Continue reading How to get sp_readerrorlog output into table and sending mail in html format.

Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses.   Implementation:Migrating SQL server reports from from one server to another server. Scenario: Lets say,Client wants to migrate their Reports from one server to another server and …

Continue reading Migrating Sql Server Reports from one server to another server.

Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses.  Implementation :How to monitor multiple sql servers from any one of the master server. Solution:First of all let us see what is it.. Scenario:Let's say you are at …

Continue reading Monitoring Multiple Servers from Master SQL Server