CoderCoderCoder

USE [master] GO ALTER DATABASE [soapnmteach] SET RECOVERY SIMPLE WITH NO_WAIT GO USE [soapnmteach] DBCC SHRINKFILE (soapnmteach_log, 1) GO USE [soapnmteach] DBCC SHRINKFILE (soapnmteach, 1) GO USE [master] GO ALTER DATABASE [soapnmteach] SET RECOVERY FULL WITH NO_WAIT GO

Just a quick reminder: INSERT INTO dbo.TargetTable (    FirstName,    MiddleInitial,    LastName,    EmployeeID,    DepartmentNumber ) SELECT    FirstName,    MiddleInitial,    LastName,    EmployeeID,    DepartmentNumber FROM    dbo.SourceTable