SQLServerCentral.com Scripts tagged Administration, SQL Server 2005http://www.sqlservercentral.com/Scripts tagged Administration, SQL Server 2005 posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)The Ultimate Foreign Key ResearcherSearches for actual and potential foreign key columns for a given primary key reference.http://www.sqlservercentral.com/scripts/T-SQL/63509/2008/06/20http://www.sqlservercentral.com/scripts/T-SQL/63509/The Ultimate Precompiled Procedure SearcherSearches precompiled procedures for the provided search string, optionally limiting to names matching a 2nd search string.http://www.sqlservercentral.com/scripts/SQL+Server+2005/63508/2008/06/20http://www.sqlservercentral.com/scripts/SQL+Server+2005/63508/Logins created in the last X DaysThese scripts give you the list of logins created in the Last X Days for SQL Server 2000 or 2005.http://www.sqlservercentral.com/scripts/Administration/63401/2008/06/08http://www.sqlservercentral.com/scripts/Administration/63401/usp_SecurCreation - SQL 2k5Creates statements for securables creation.http://www.sqlservercentral.com/scripts/Administration/63173/2008/06/30http://www.sqlservercentral.com/scripts/Administration/63173/usp_ActiveProcesses - SQL 2k5Returns list of active processes and their buffer contents over a specified time.http://www.sqlservercentral.com/scripts/Administration/63169/2008/07/02http://www.sqlservercentral.com/scripts/Administration/63169/usp_IndexesUnused - SQL 2k5Checks index usagehttp://www.sqlservercentral.com/scripts/Administration/63167/2008/06/24http://www.sqlservercentral.com/scripts/Administration/63167/usp_ShowOrphanUsers - SQL 2k5Check Orphaned logins ie, not associated with any database on the current instance.http://www.sqlservercentral.com/scripts/Administration/63164/2008/07/16http://www.sqlservercentral.com/scripts/Administration/63164/Verify Last successful CHECKDB on all databasesCreates a resultset that expresses the last time a successful CHECKDB was performed on every database in the instance. Does not work on SQL 2000.http://www.sqlservercentral.com/scripts/Administration/62598/2008/04/29http://www.sqlservercentral.com/scripts/Administration/62598/Table Information View -- No Cursors!Row counts and storage space information for all tables in the database.http://www.sqlservercentral.com/scripts/tables/62545/2008/04/08http://www.sqlservercentral.com/scripts/tables/62545/SQL Server 2005 - Backup, Integrity Check and Index OptimizationSolution for Backup, Integrity Check and Index Optimization in SQL Server 2005.http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/62380/2008/04/15http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/62380/Available bytes for row expansion (adding columns) in a tableThis scalar function accepts a table name and returns the number of bytes left out of the 8060 bytes available for adding new columns. http://www.sqlservercentral.com/scripts/SQL+Server+2005/62190/2008/04/03http://www.sqlservercentral.com/scripts/SQL+Server+2005/62190/Get record count for a specific databaseThis will sum all of the records of a specified database, excluding the 'sysdiagrams' table.http://www.sqlservercentral.com/scripts/Administration/61766/2008/02/11http://www.sqlservercentral.com/scripts/Administration/61766/2005 Database Monitor RDL for Management StudioRDL for use in MSSSQL 2005's Management Studio (custom reports). http://www.sqlservercentral.com/scripts/SQL+Server+2005/61179/2007/12/04http://www.sqlservercentral.com/scripts/SQL+Server+2005/61179/