SQLServerCentral - Scripts by Vinay Kumar

Copy Sql Objects

Copy tables, procedures, functions and view from one schema and another schema. Read more...

By Vinay Kumar 2013/03/29 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 686 reads

Copy Table

Copy tables from one schema to another schema. Read more...

By Vinay Kumar 2013/04/03 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 898 reads

Create Table with T-SQL

Generate create table statement using T-SQL. Read more...

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

Rating:

|

Discuss |

Briefcase | 1,092 reads

Get Database Size

Know you database size Read more...

By Vinay Kumar 2013/02/18 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 1,613 reads

Print The Calendar 2

This script will print the calendar from the given date. Read more...

By Vinay Kumar 2012/08/10 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 1,525 reads

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 | 900 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 | 1,034 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,540 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,430 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,311 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,366 reads

Generate Insert Statements

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

By Vinay Kumar 2013/05/21 | Source: SQLServerCentral.com | Category: primary key (pk)

Rating:

|

Discuss |

Briefcase | 1,598 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 2013/05/21 | Source: SQLServerCentral.com

Rating: (not yet rated) |

Discuss |

Briefcase | 851 reads

Enable Disable All Triggers in a Database

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

By Vinay Kumar 2011/11/18 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 2,495 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,204 reads