<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_top"><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
Blogs
QotD
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Scripts with tag
Administration
Refine your search with one of the following additional tags (with number of items):
SQL Server 2005
(6)
Backup
(1)
Normalization
(1)
Storage
(1)
Index Management
(2)
Backup / Restore
(1)
Programming
(1)
String Manipulation
(1)
Maintenance and Management
(2)
Maintenance
(1)
SQL 2005
(1)
Table Valued Function
(1)
T-SQL
(2)
Management
(1)
SQL Server 2000
(1)
tables
(1)
Automation
(1)
Search for
any
content tagged
Administration
Add a script
Items 1 to 20 of 24
Next 20 >>
When sp_depends fails
sp_depends may not always return accurate information
Read more...
By
Jano Petras
2008/05/27
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
28 reads
Delete files older than n-days via T-SQL
Delete files on a fileshare leaving behind files not older than n-days.
Read more...
By
Gordon
2008/06/05
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
115 reads
SQL 2005 - List Primary Key Columns
Will list Table Name, Constraint name and Primary Key Column Name
Read more...
By
Sandeep Saretha
2008/05/16
|
Source:
SQLServerCentral.com
|
Category:
Normalization
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
100 reads
Verify Last successful CHECKDB on all databases
Creates a resultset that expresses the last time a successful CHECKDB was performed on every database in the instance. Does not work on SQL 2000.
Read more...
By
Kyle Neier
2008/04/29
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
726 reads
Table Information View -- No Cursors!
Row counts and storage space information for all tables in the database.
Read more...
By
RBarryYoung
2008/04/08
|
Source:
SQLServerCentral.com
|
Category:
tables
Rating:
|
Discuss
|
Briefcase
|
1,401 reads
An easy way to track the growth of your database
This query gives you an idea of the growth of your database over time.
Read more...
By
Sylvia Moestl Vasilik
2008/05/07
|
Source:
SQLServerCentral.com
|
Category:
Backup
Rating:
|
Discuss
|
Briefcase
|
1,003 reads
SQL Server 2005 - Backup, Integrity Check and Index Optimization
Solution for Backup, Integrity Check and Index Optimization in SQL Server 2005.
Read more...
By
Ola Hallengren
2008/04/15
|
Source:
SQLServerCentral.com
|
Category:
Backup / Restore
Rating:
|
Discuss
|
Briefcase
|
2,738 reads
Compare Different tables from 2 Databases
List tables that have different tables and column
Read more...
By
jrtupa
2008/04/07
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
1,543 reads
Find and Replace a String in the Whole Database
Find and Replace a string in all string fields (char, varchar, etc) of all tables in the database
Read more...
By
Luiz Barros
2008/04/11
|
Source:
SQLServerCentral.com
|
Category:
String Manipulation
Rating:
|
Discuss
|
Briefcase
|
1,241 reads
Available bytes for row expansion (adding columns) in a table
This scalar function accepts a table name and returns the number of bytes left out of the 8060 bytes available for adding new columns.
Read more...
By
ruchir
2008/04/03
|
Source:
SQLServerCentral.com
|
Category:
SQL Server 2005
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
332 reads
2005 Blocking Locks RDL for Management Studio
RDL for use in MSSSQL 2005's Management Studio (custom reports).
Read more...
By
Tommy Bollhofer
2008/03/28
|
Source:
SQLServerCentral.com
|
Category:
SQL 2005
Rating:
|
Discuss
|
Briefcase
|
594 reads
Generate Scripts to Compare Tables
Generate the scripts that will allow you to compare tables pass/fail.
Read more...
By
Absinthe
2008/02/06
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
3,057 reads
Modify columns' name in batches
Modify columns' name in batches.
Read more...
By
hxd001_810
2008/02/14
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
500 reads
Get record count for a specific database
This will sum all of the records of a specified database, excluding the 'sysdiagrams' table.
Read more...
By
James Rea
2008/02/11
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
5,573 reads
Get Modified Objects As on Date
This table Valued Function return the Modified Objects (SP /Views) For the Date specified.
Read more...
By
BeoWulf .
2008/01/30
|
Source:
SQLServerCentral.com
|
Category:
Table Valued Function
Rating:
|
Discuss
|
Briefcase
|
481 reads
Locate specific columns used in procs
SP to find object and line number that references column(s) of interest.
Read more...
By
Damien Alvarado
2008/01/24
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
628 reads
SMS Script
This script will modify INI file on destops through SMS push to point server connection from A to B.
Read more...
By
Jay Dave
2008/01/09
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
614 reads
Check owners, collations and backups
A script to check the owners, collations and backups on the server.
Read more...
By
paul_richardson
2008/01/01
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
839 reads
2005 unused indexes
Shows unused indexes compared to nr of modifications
Read more...
By
Wilfred van Dijk
2007/12/18
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
1,227 reads
How to empty database
Sometimes you need to empty the content of database. Following script can do that for you.
Read more...
By
Boka
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
1,494 reads
Items 1 to 20 of 24
Next 20 >>
Most popular
Get record count for a specific database
This will sum all of the records of a specified database, excluding the 'sysdiagrams' table.
Read more...
By
James Rea
2008/02/11
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
5,573 reads
Generate Scripts to Compare Tables
Generate the scripts that will allow you to compare tables pass/fail.
Read more...
By
Absinthe
2008/02/06
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
3,057 reads
SQL Server 2005 - Backup, Integrity Check and Index Optimization
Solution for Backup, Integrity Check and Index Optimization in SQL Server 2005.
Read more...
By
Ola Hallengren
2008/04/15
|
Source:
SQLServerCentral.com
|
Category:
Backup / Restore
Rating:
|
Discuss
|
Briefcase
|
2,738 reads
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use
