SQLServerCentral - Scripts by abmore

Kill Active connections

Simple Script to kill all active connection from current database. Read more...

By abmore 2009/10/21 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 2,095 reads

Ultimate Alter Script generator

In development enviornment we always get the modifications in tables from developers.As far as my concern writing scripts is tedious work for us. I hope below script will help you. Read more...

By abmore 2009/10/30 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 1,086 reads

XML Index

Checking XML indexs with a sample. Read more...

By abmore 2008/09/19 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 1,274 reads

Using sp_xml_preparedocument

Using sp_xml_preparedocument and sp_xml_removedocument Read more...

By abmore 2013/05/19 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 1,267 reads

Get Missing Index info

A script to get the missing index information for a table. Read more...

By abmore 2008/09/08 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 1,142 reads

Script to return Rows count from table using sp_ExecuteSQL

Script to return Rows count from table using sp_ExecuteSQL Read more...

By abmore 2008/09/26 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 1,415 reads

Delete Duplicate values

Delete duplicate values from table Read more...

By abmore 2008/10/10 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 1,783 reads

Table Partitioning in SQL Server 2005

Sample script for Table Partition Read more...

By abmore 2013/05/19 | Source: SQLServerCentral.com | Category: partition

Rating:

|

Discuss |

Briefcase | 1,799 reads

Refresh All Views

Refresh All views in Current Database. Read more...

By abmore 2008/01/28 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 1,502 reads

BackUp database

BackUp database Read more...

By abmore 2008/01/29 | Source: SQLServerCentral.com | Category: backup / restore

Rating:

|

Discuss |

Briefcase | 1,799 reads

Get Modified Objects As on Date

This table Valued Function return the Modified Objects (SP /Views) For the Date specified. Read more...

By abmore 2011/10/07 | Source: SQLServerCentral.com | Category: table valued function

Rating:

|

Discuss |

Briefcase | 1,316 reads

setting full text search using script

This script will help you to understand how to set & use full text search. Read more...

By abmore 2013/05/19 | Source: SQLServerCentral.com | Category: full-text search

Rating:

|

Discuss |

Briefcase | 494 reads

Clear all the data from tables

This script will delete all rows from the database, except system tables. Read more...

By abmore 2007/11/26 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 1,631 reads

Get dependant Objects

Get Dependant Objects by passing table name or stored procedure name. Read more...

By abmore 2012/08/24 | Category: t-sql

Rating:

|

Discuss |

Briefcase | 1,512 reads