http://www.sqlservercentral.com/Scripts tagged Administration posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)This stored procedure move the LDF or MDF to a new location.http://www.sqlservercentral.com/scripts/Administration/63854/2008/07/25http://www.sqlservercentral.com/scripts/Administration/63854/Generates a list of ALL Users and their database Roles for all Databases (Or for a specific user).http://www.sqlservercentral.com/scripts/Administration/63841/2008/07/24http://www.sqlservercentral.com/scripts/Administration/63841/This script will generate a script that would create a Role called "db_SprocReader" and grants "View Definition" permissions to all the stored procedures.http://www.sqlservercentral.com/scripts/Administration/63816/2008/07/23http://www.sqlservercentral.com/scripts/Administration/63816/Services uptime can be checked through WMI scripts and other methods also. As a DBA most of us would like to know the uptime of SQL Serverhttp://www.sqlservercentral.com/scripts/Administration/63771/2008/07/19http://www.sqlservercentral.com/scripts/Administration/63771/Here's a script, for killing a SPIDs against a particular database, here am using BIN as the database. http://www.sqlservercentral.com/scripts/Administration/63734/2008/07/17http://www.sqlservercentral.com/scripts/Administration/63734/To find a list of Tables (User or System tables)according to their size.http://www.sqlservercentral.com/scripts/Administration/63646/2008/07/10http://www.sqlservercentral.com/scripts/Administration/63646/function which checks a database on availabilityhttp://www.sqlservercentral.com/scripts/Administration/63637/2008/07/09http://www.sqlservercentral.com/scripts/Administration/63637/Find every object in every database owned by a particular Login.http://www.sqlservercentral.com/scripts/Administration/63631/2008/07/07http://www.sqlservercentral.com/scripts/Administration/63631/Get a report of all your SQL jobs in HTML Formathttp://www.sqlservercentral.com/scripts/Administration/63615/2008/07/03http://www.sqlservercentral.com/scripts/Administration/63615/Searches 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/Searches 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/check public access to extended stored procedureshttp://www.sqlservercentral.com/scripts/T-SQL/63421/2008/06/16http://www.sqlservercentral.com/scripts/T-SQL/63421/These 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/Grant permissions to specific objects in Database using dynamic SQL.http://www.sqlservercentral.com/scripts/Administrator/63399/2008/06/08http://www.sqlservercentral.com/scripts/Administrator/63399/GRANT Column Level Permissionshttp://www.sqlservercentral.com/scripts/T-SQL/63398/2008/06/08http://www.sqlservercentral.com/scripts/T-SQL/63398/Search for String Occurence with this script in your stored procedures.http://www.sqlservercentral.com/scripts/Search/63397/2008/06/08http://www.sqlservercentral.com/scripts/Search/63397/the script has been developed on SQL server 2005 and gives the ability to find out from all active jobs the precentage of running time divided to job interval in the last 24 hours.http://www.sqlservercentral.com/scripts/Administration/63245/2008/07/07http://www.sqlservercentral.com/scripts/Administration/63245/SHOW WHICH TABLES ARE MODIFIED BY A STORED OR FUNCTION OR WHICH STORED OR FUNCTION MODIFIES A TABLEhttp://www.sqlservercentral.com/scripts/Utility/63185/2008/06/27http://www.sqlservercentral.com/scripts/Utility/63185/Creates statements for securables creation.http://www.sqlservercentral.com/scripts/Administration/63173/2008/06/30http://www.sqlservercentral.com/scripts/Administration/63173/Creates statements for securables creation.http://www.sqlservercentral.com/scripts/Administration/63172/2008/06/26http://www.sqlservercentral.com/scripts/Administration/63172/Returns 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/Checks index usagehttp://www.sqlservercentral.com/scripts/Administration/63167/2008/06/24http://www.sqlservercentral.com/scripts/Administration/63167/Check 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/sp_depends may not always return accurate informationhttp://www.sqlservercentral.com/scripts/Administration/62801/2008/05/27http://www.sqlservercentral.com/scripts/Administration/62801/Delete files on a fileshare leaving behind files not older than n-days.http://www.sqlservercentral.com/scripts/Administration/62729/2008/06/05http://www.sqlservercentral.com/scripts/Administration/62729/Will list Table Name, Constraint name and Primary Key Column Namehttp://www.sqlservercentral.com/scripts/Normalization/62620/2008/05/16http://www.sqlservercentral.com/scripts/Normalization/62620/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.http://www.sqlservercentral.com/scripts/Administration/62598/2008/04/29http://www.sqlservercentral.com/scripts/Administration/62598/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/This query gives you an idea of the growth of your database over time.http://www.sqlservercentral.com/scripts/Backup/62497/2008/05/07http://www.sqlservercentral.com/scripts/Backup/62497/Solution 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/