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. ISSUE: Unable to perform distributed transaction in sql linked server and event viewer captures the error like 'ITransactionDispenser:0x8007138f(The cluster resource could not be found'. Follow the best …
A timeout (30000 milliseconds) was reached while waiting for a transaction response from the MSSQLSERVER service
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. ISSUE: A timeout (30000 milliseconds) was reached while waiting for a transaction response from the MSSQLSERVER service. Follow the best link which I have found on …
Get SQL Server agent Service Stopped Mail Notification
Implementation: Get a mail alert via powershell when SQL server agent service gets stopped. Scenario: When SQL server agent service gets stopped,its dependence jobs,DR,operators,DB mail,replication failed to succeed.In these case,you can have a mail alert which will notify whenever agent service gets stopped by triggering mail to provided mail id via windows powershell. Infrastructure:The below query/steps have …
Continue reading Get SQL Server agent Service Stopped Mail Notification
Use a variable in an ALTER DATABASE command
Note: Best viewed in Internet Explorer 6 and above Implementation: How to use a variable in an ALTER database command. Scenario: Lets say,you want to use a variable in an ALTER DATABASE for putting all or selected DBs offline/online/attach/detach purpose. Infrastructure:The below query/procedure has been run/tested successfully on sql server 2005,2008,2008 R2 and 2012. Kindly find the below …
Continue reading Use a variable in an ALTER DATABASE command
Move MSDB & MODEL databases to another location without downtime [without start\stop SQL service]
Note:Best viewed in Internet Explorer 6 and above Implementation: Moving the msdb,model databases without SQL service start and stop. Scenario: Lets say you are suppose to move the system databases(msdb,model) not tempdb and master to another location without SQL service start and stop operations. Below some steps will help you out for getting done above …
Get ping result of multiple server into SQL table
Note: Best viewed in Internet Explorer 6 and above Implementation: How to get ping result of multiple servers into SQL table. Scenario: Lets say you manage multiple DB servers solely and in your day to day monitoring activities list,you have to first check all server running status by pinging them. So how will you achieve this?? will …
Continue reading Get ping result of multiple server into SQL table
Get SQL Server Jobs detail history based on last run day and time
Note: Best viewed in Internet Explorer 6 and above Implementation: How to get SQL Server Jobs detail history based on last run day(no of days) and time(minutes) Scenario: Lets find out SQL Server Jobs detail history based on last run day(no of days) and time(minutes) Infrastructure:The below query/procedure has been run/tested successfully on sql server 2005,2008,2008 R2 and 2012. …
Continue reading Get SQL Server Jobs detail history based on last run day and time
Get CPU utilization history in SQL Server
Note: Best viewed in Internet Explorer 6 and above Implementation: How to get CPU utilization history in SQL Server. Scenario: Lets find out the CPU Utilization history based on minutes/hours. Infrastructure:The below query/procedure has been run/tested successfully on sql server 2008 R2. Steps: Create the table from using below query in any database-One time table creation. USE [master] …
The report server can not open a connection to the report server database while opening reports in sql server database
Below is the error which I faced at one of my client while opening SQL server reports. Error: While opening reports from browser,faced the below error. Issue Reported: The report server can not open a connection to the report server database.While opening reports from url. Analysis: The report server database or user database which was used for report server …
User Domain\User Account does not have required permissions error while migrating reports from one server to another server
Below is the error which I faced at one of my client while migrating SQL server reports from one server to another server. Error: While migrating SQL server reports from one server to another server faced the below user permission error. Issue Reported: While Migrating reports from one sql server to another server the Domain\user permission error thrown. …
ADsql-Tech Forever 
You must be logged in to post a comment.