<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 tags
SQL Server 2005
,
Administration
Refine your search with one of the following additional tags (with number of items):
Maintenance and Management
(4)
SQL Server 2000
(2)
Logins
(1)
sys.foreign_key_columns
(1)
Security
(3)
T-SQL
(2)
Management
(1)
sys.foreign_keys
(1)
Index Management
(2)
T-SQL Aids
(2)
Search Stored PRocedures
(1)
sys.sql_modules
(1)
Maintenance
(2)
Backup / Restore
(1)
Storage
(1)
tables
(1)
Search
(2)
Search for
any
content tagged
SQL Server 2005 & Administration
Add a script
Items 1 to 13 of 13
The Ultimate Foreign Key Researcher
Searches for actual and potential foreign key columns for a given primary key reference.
Read more...
By
Jesse Roberge
2008/08/15
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
116 reads
The Ultimate Precompiled Procedure Searcher
Searches precompiled procedures for the provided search string, optionally limiting to names matching a 2nd search string.
Read more...
By
Jesse Roberge
2008/08/29
|
Source:
SQLServerCentral.com
|
Category:
SQL Server 2005
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
79 reads
Logins created in the last X Days
These scripts give you the list of logins created in the Last X Days for SQL Server 2000 or 2005.
Read more...
By
Mani Singh
2008/07/30
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
219 reads
usp_SecurCreation - SQL 2k5
Creates statements for securables creation.
Read more...
By
Pedro Lopes
2008/06/30
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
650 reads
usp_ActiveProcesses - SQL 2k5
Returns list of active processes and their buffer contents over a specified time.
Read more...
By
Pedro Lopes
2008/07/02
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
678 reads
usp_IndexesUnused - SQL 2k5
Checks index usage
Read more...
By
Pedro Lopes
2008/06/24
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
973 reads
usp_ShowOrphanUsers - SQL 2k5
Check Orphaned logins ie, not associated with any database on the current instance.
Read more...
By
Pedro Lopes
2008/07/16
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
718 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
|
1,081 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
|
2,664 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
|
4,764 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
|
432 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
|
8,034 reads
2005 Database Monitor RDL for Management Studio
RDL for use in MSSSQL 2005's Management Studio (custom reports).
Read more...
By
Tommy Bollhofer
2007/12/04
|
Source:
SQLServerCentral.com
|
Category:
SQL Server 2005
Rating:
|
Discuss
|
Briefcase
|
1,775 reads
Items 1 to 13 of 13
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
|
8,034 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
|
4,764 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
|
2,664 reads
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use
