Sql job failed to notify via email – Error SQL Server Agent
The common error appear on the Agent Job is “Sql job failed to notify via email”. Below we will explain some of the ways to fix this error.
Get IT Solutions
How to do IT
Category: Database
Find location of SQL Server Error Log File – ERRORLOG
We are going to discuss 5 methods to find location of SQL Server Error Log File. We will expose different ways for a DBA to identify SQL Server Error log location.
How to Fix Microsoft SQL Server error 233 – Login failed
When try to access the database sometimes on users appear “ Microsoft SQL Server error 233 “. This is very general connection error and to fix this you will need to test different solutions.
Microsoft SQL Server Error 229 – Permission Error Solutions
The common error when you try to access any table or to perform select on sql server is “Microsoft sql server error 229”. This error is related with the permission on certain database.
Microsoft SQL server error 300 – VIEW SERVER STATE permission solutions
Every DBA has faced Sql server error 300 on the daily works. The massage is “VIEW SERVER STATE permission was denied on object 'server', database 'master'. (Microsoft SQL Server, Error: 300)”. The error is related with user permission on VIEW SERVER STATE. Some people experiences are …
SQL Server restore master database in fast mode – CMD
The SQL Server restore master database article will explain the fast and easy method to perform restoring of the most important database.
Sql server move database files to another drive in fastest way – data and log
Sometimes we need on SQL Server move database files to another drive. In this article we will try to explain 3 easy methods to perform this task.
Find SQL Server Version Query – CMD – Edition and Service Pack
Sometimes we need to find sql server version number, edition or update level. The article using various ways to find those information of SQL Server.
Sql server: disable all sql jobs at once using TSQL script – Agent Jobs
This article explain tips for SQL Server disable all sql jobs topic, using specific name or using specific category. We need to disable or Enable all jobs?