<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Search:
Home
Articles
Editorials
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Scripts by SQL Species
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
SQL Species
2009/10/21
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
865 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
SQL Species
2009/10/30
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
571 reads
XML Index
Checking XML indexs with a sample.
Read more...
By
SQL Species
2008/09/19
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
714 reads
Using sp_xml_preparedocument
Using sp_xml_preparedocument and sp_xml_removedocument
Read more...
By
SQL Species
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
413 reads
Get Missing Index info
A script to get the missing index information for a table.
Read more...
By
SQL Species
2008/09/08
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
806 reads
Script to return Rows count from table using sp_ExecuteSQL
Script to return Rows count from table using sp_ExecuteSQL
Read more...
By
SQL Species
2008/09/26
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
1,063 reads
Delete Duplicate values
Delete duplicate values from table
Read more...
By
SQL Species
2008/10/10
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
1,411 reads
Table Partitioning in SQL Server 2005
Sample script for Table Partition
Read more...
By
SQL Species
|
Source:
SQLServerCentral.com
|
Category:
partition
Rating:
|
Discuss
|
Briefcase
|
451 reads
Refresh All Views
Refresh All views in Current Database.
Read more...
By
SQL Species
2008/01/28
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
976 reads
BackUp database
BackUp database
Read more...
By
SQL Species
2008/01/29
|
Source:
SQLServerCentral.com
|
Category:
Backups
Rating:
|
Discuss
|
Briefcase
|
938 reads
Get Modified Objects As on Date
This table Valued Function return the Modified Objects (SP /Views) For the Date specified.
Read more...
By
SQL Species
2008/01/30
|
Source:
SQLServerCentral.com
|
Category:
Table Valued Function
Rating:
|
Discuss
|
Briefcase
|
771 reads
setting full text search using script
This script will help you to understand how to set & use full text search.
Read more...
By
SQL Species
|
Source:
SQLServerCentral.com
|
Category:
Full-Text Search
Rating:
|
Discuss
|
Briefcase
|
131 reads
Clear all the data from tables
This script will delete all rows from the database, except system tables.
Read more...
By
SQL Species
2007/11/26
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
1,391 reads
Get dependant Objects
Get Dependant Objects by passing table name or stored procedure name
Read more...
By
SQL Species
2007/11/27
|
Category:
T-SQL
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
653 reads
Get Splitted Value From the String Format Specifie
Read more...
By
SQL Species
|
Category:
T-SQL Aids
Rating:
|
Discuss
|
Briefcase
|
155 reads
Items 1 to 15 of 15
Copyright © 2002-2009 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use
