When I saw the code Getting All the Information of the Server in SQL Server – MSSQL Query, I thought to share mine.This more or less sums the general MS SQL instance information Good Luck
Tag: SQL Server
TSQL – working with folders and output to file
This article shows how to create a folder for backup. The idea is to create folder with date part in its name, and then backup a specific database to that folder. First we need to create a parameters to save our SQL command in it. use master declare @sql1 nvarchar(max) declare @sql2 nvarchar(max) declare @var1 …