Execute the following Microsoft SQL Server T-SQL scripts to perform various actions:

-- Estimate tempdb space for CHECKDB

DBCC CHECKDB(AdventureWorks2008) with ESTIMATEONLY

------------

-- DROP Windows login from SQL Server

USE master;

EXEC sp_revokelogin 'FinanceNET\jsmith'

------------

-- CHANGE database recovery model

ALTER DATABASE AdventureWorks2008 SET RECOVERY SIMPLE

-------

-- SQL Server 2000 - pin frequently used table into memory

-- You have to have sufficient memory to use this feature

use pubs

DECLARE @db_id int, @tbl_id int

SET @db_id = DB_ID('pubs')

SET @tbl_id = OBJECT_ID('pubs..authors')

DBCC PINTABLE (@db_id, @tbl_id)

------------

-- Find all foreign keys pointing to / referencing this table PK

USE AdventureWorks2008;

EXEC sp_fkeys @pktable_name = N'Product'

    ,@pktable_owner = N'Production'

/* Partial results

FKTABLE_QUALIFIER FKTABLE_OWNER     FKTABLE_NAME      FKCOLUMN_NAME

AdventureWorks2008      Production  BillOfMaterials   ComponentID

AdventureWorks2008      Production  BillOfMaterials   ProductAssemblyID

AdventureWorks2008      Production  ProductCostHistory ProductID

AdventureWorks2008      Production  ProductDocument   ProductID

*/
------------

Related links:

Rename File with Date Suffix

Get List of Files in a Folder/Directory