MS SQL – Copying a Linked Server Table
I recently used the following TSQL on a Microsoft SQL server to create and populate a table ...
Read Moreby Phil Eddies | Dec 6, 2020 | Scripts, SQL | 0 |
I recently used the following TSQL on a Microsoft SQL server to create and populate a table ...
Read Moreby Phil Eddies | Jun 3, 2018 | Scripts, SQL | 7 |
The following is an example PowerShell script to connect to a Microsoft SQL Database and dump the...
Read Moreby Phil Eddies | Dec 21, 2015 | Scripts, SQL | 0 |
The below SQL snippet will return a count of the number of tables in a database. Make sure to...
Read Moreby Phil Eddies | Mar 19, 2015 | Scripts, SQL | 0 |
The below SQL script will return a list of tables in a database along with the table sizes in MB....
Read Moreby Phil Eddies | Aug 23, 2013 | Scripts, SQL | 0 |
Disabling and Enabling All SQL Server Agent Jobs As part of a recent Microsoft SQL Server migration project I had a need to disabled and enable all of the Agent Jobs as various points, the below scripts did the job. This scripts...
Read Moreby Phil Eddies | Dec 21, 2012 | Scripts, SQL | 0 |
Getting a list of databases on a MS SQL Server The below query will return a list of none system...
Read More
Recent Comments