Category: SQL Server

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.

Full Article

No Comments

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?

Full Article

No Comments

FIX sqlstate 42000 – mysql error 1064 – you have an error in your sql syntax

Sqlstate 42000 Is a general code that come together with other number. Most often comes with the code 1064 and ...
Read More

The execute permission was denied on the object – SQL Server Error

The following article will handle “the execute permission was denied on the object” error appears on SQL Server. This error ...
Read More

How to Read Data from LDF file in SQL Server – A Complete Guide

Hello Everyone, Today we are going to address the most popular query of SQL users, how to read data from ...
Read More

3 Method to Delete Temp Files in Windows 7/10 including vbs script

Fastest way to delete hiberfil sys from windows 10/8/7 and XP – CMD