Exec on Linked Server

Dynamic SQL

Generate Data Script for a Table

This script takes a table as parameter and generate its data script (INSERT INTO TABLE).

Extract Objects of a Linked Server

In a scenario where we need to find out all the objects of a LINKED Server and check which object is accessible to us,

we need to write following query:

Extract User-Role Mapping

This short script will list all the users along with their Roles.

Table Variables

TSQL

Get Record count of all tables of current database

This script will return record count of all user tables from the current database