SQLServerCentral - Scripts by Sudhir Chawla

Generate Data Script for a Table

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

By Sudhir Chawla 2009/09/21 | Source: SQLServerCentral.com | Category: generate scripts

Rating:

|

Discuss |

Briefcase | 1,961 reads

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: Read more...

By Sudhir Chawla 2009/08/07 | Source: SQLServerCentral.com | Category: linked server

Rating: (not yet rated) |

Discuss |

Briefcase | 614 reads

Extract User-Role Mapping

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

By Sudhir Chawla 2008/12/23 | Source: SQLServerCentral.com | Category: administration

Rating:

|

Discuss |

Briefcase | 2,611 reads

Get Record count of all tables of current database

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

By Sudhir Chawla 2013/06/17 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 977 reads