<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
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Scripts with tag
Administration
Search for
any
content tagged
administration
Add a script
Items 1 to 20 of 149
Next 20 >>
Script to change auto growth settings for all databases in SQL Server
Script to change auto growth settings for all databases in SQL Server.
Read more...
By
Shashank Srivastava
2013/05/28
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
608 reads
List of Stored Procedures modified in past 7 days
Provide list of Stored Procedures that have been changed in past 7 days.
Read more...
By
Nitesh Dedhia
2013/04/24
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
1,592 reads
Script to find the total used size of all database inside SQL Server
Script to find the total used size of all database inside SQL Server
Read more...
By
Shashank Srivastava
2013/04/19
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
1,281 reads
List all tables and their respective information.
List all tables in a SQL Server database with the details of them.
Read more...
By
Fernando Casas Osorio
2013/03/14
|
Source:
SQLServerCentral.com
|
Category:
tables
Rating:
|
Discuss
|
Briefcase
|
2,154 reads
Get Rid of All Those Pesky 1 MB File Growth DB Files
Use sp_MSForeEachDB to set all 1 MB file growth databases to 10%.
Read more...
By
Greg Milner
2013/05/31
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
1,221 reads
Shrinking all log files on SQL Server 2008R2
It shrinks all log files for the databases created by users.
Read more...
By
Igor Micev
2012/11/02
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
1,468 reads
SQL Server Uptime
This script is used to get uptime for the SQL Server. (Supports SQL2005 and onwards only)
Read more...
By
Chandu Ade
2012/09/28
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
1,094 reads
Search for an object across multiple databases on a server.
There are other options available like Sql search from Red Gate. Here's a simple script to search for objects(s) containing a particular keyword.
Read more...
By
Kishore Tallapragada
2013/04/15
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
2,687 reads
Display Names and Locations of SQL Database Files and DB Owners
Displays the names of all of the SQL databases on a SQL Server instance, their data and transaction log files, their owner, and their physical locations.
Read more...
By
Charles Brinkman
2012/08/20
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
1,285 reads
Count of Objects by Database on a Server
I needed to get a count of objects by database on a server to assess which dbs are good candidates for Red Gate SQL Source Control.
Read more...
By
Joe Kennedy
2012/08/07
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
596 reads
Finding Unused Database Roles
This is a data quality script that locates unused Database Roles for maintenance purposes
Read more...
By
Brandie Tarvin
2012/07/24
|
Source:
SQLServerCentral.com
|
Category:
database roles
Rating:
|
Discuss
|
Briefcase
|
1,181 reads
All SQL Version info in one function
This function returns all the necessary version information in a table.
Read more...
By
Wilfred van Dijk
2012/05/28
|
Source:
SQLServerCentral.com
|
Category:
version
Rating:
|
Discuss
|
Briefcase
|
2,911 reads
View Active Session SQL
This script can be used to view current SQL statements being executed for all or any one SPID.
Read more...
By
David Kranes
2012/02/24
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
2,894 reads
Wait Time - Query\Client
Script helps to get the client and queries that generate longer waiting time.
Read more...
By
Wellington Vitoriano
2011/11/07
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
1,310 reads
Database Files Physical Location
Displaying the SQL Database names and its associated files in the System drives in which the files are stored / mapped.
Read more...
By
Mohamed Qasim
2011/11/11
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
1,065 reads
Next grow for all databases per disk
This script lets you to know how much disk space will be left after the next database grow taking in account the free space left in the database.
Read more...
By
Gonzalo Moles
2011/10/11
|
Source:
SQLServerCentral.com
|
Category:
maintenance
Rating:
|
Discuss
|
Briefcase
|
921 reads
sp_who3
A compatibility view for DBAs used to using sp_who2
Read more...
By
gerhard-356547
2011/08/01
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
2,776 reads
Get information from tables
Give information in tables such as type size and description of each of the columns
Read more...
By
kenneth9
2011/07/08
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
1,371 reads
Verify a database backup using T-SQL
A script to verify a database backup using T-SQL code
Read more...
By
Nakul Vachhrajani
2011/07/11
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
1,522 reads
Backup all databases & check backups
Stored procedure to backup all DB (chose user or system). You can do full, differential and log backups
Read more...
By
Pavle-192195
2011/05/13
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
2,560 reads
Items 1 to 20 of 149
Next 20 >>
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
