Script to Generate Job Scripts – SQL Server

The following script generates the “Job Details” as in script form. I struggled a lot to migrate jobs from one server to another server and decided to write a script …

Read More

SQL Server Space Usage

In order to determine the space used by a database in SQL Server we use the following command The above command, on execution gives two tables as output. First table …

Read More