SQLServerCentral - Scripts by Vinay Kumar

Copy Multiple objects from One Schema to Another Schema

Copy Multiple objects from One Schema to Another Schema Read more...

By Vinay Kumar 2011/09/30 | Source: SQLServerCentral.com

Rating:

|

Discuss |

Briefcase | 765 reads

Copy One Schema to Another Schema

This script copies one object in another multiple schema. Read more...

By Vinay Kumar 2011/08/31 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 894 reads

Create Database User

This script is used for drop and create a new or existing user. IF User is already exists in database then first it will dropped and then recreate. Read more...

By Vinay Kumar 2011/05/05 | Source: SQLServerCentral.com | Category: security

Rating:

|

Discuss |

Briefcase | 1,355 reads

Kill The Sessions

This script kill the user session for particular user database. Read more...

By Vinay Kumar 2011/04/26 | Source: SQLServerCentral.com

Rating:

|

Discuss |

Briefcase | 2,221 reads

Store Procedure Output in a Table

This script show a demonstration of how to interst tore Procedure Output in a Table. Read more...

By Vinay Kumar 2010/01/08 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 2,227 reads

Database Sizes

This script slow all the user and sys dbs size. Read more...

By Vinay Kumar 2009/02/16 | Source: SQLServerCentral.com | Category: database size

Rating:

|

Discuss |

Briefcase | 2,188 reads

Generate Insert Statements

This script Generates the insert statements for a particular table. Read more...

By Vinay Kumar | Source: SQLServerCentral.com | Category: primary key (pk)

Rating:

|

Discuss |

Briefcase | 1,423 reads

Add Primary key

This Store procedure is used to add primary key to all tables in a database, if table does not contain it. Read more...

By Vinay Kumar | Source: SQLServerCentral.com

Rating: (not yet rated) |

Discuss |

Briefcase | 802 reads

Enable Disable All Triggers in a Database

Enable Disable All Triggers in a Database Read more...

By Vinay Kumar 0001/01/01 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 2,373 reads

Print The Calender

It shows the Calender. Read more...

By Vinay Kumar 2008/03/14 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 1,152 reads