Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by abmore

SQLServerCentral.com profile

   Items 1 to 15 of 15   
 

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,170 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,150 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,362 reads

Using sp_xml_preparedocument

Using sp_xml_preparedocument and sp_xml_removedocument  Read more...
By abmore 2008/07/20 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,321 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,195 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,470 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,812 reads

Table Partitioning in SQL Server 2005

Sample script for Table Partition  Read more...
By abmore 2008/07/20 | Source: SQLServerCentral.com | Category: partition
Rating: |  Discuss |   Briefcase | 1,897 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,556 reads

BackUp database

BackUp database  Read more...
By abmore 2008/01/29 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 1,904 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,343 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 2007/10/18 | Source: SQLServerCentral.com | Category: full-text search
Rating: |  Discuss |   Briefcase | 531 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,650 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,585 reads
   Items 1 to 15 of 15