Print ''
Print '-------------------------------------------------------------------------'
Print ' using Database: #DB_N#'
Print ' Creation Date : 14.08.2009'
Print ' Autor         : J.Feuerstein'
Print ' '
Print '-------------------------------------------------------------------------'

use [#DB_N#]

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

   DECLARE @ExecuteSQLstr nvarchar(max)

   print ('')
   Print ('-------- CLEAN BUFFER --------------')

   declare @DateTimeStart datetime
   set @DateTimeStart = GetDate()

   -- rem clears buffer
   print ('Step: DBCC DROPCLEANBUFFERS')
   DBCC DROPCLEANBUFFERS


   print ('Step: DBCC FREEPROCCACHE')
   DBCC FREEPROCCACHE

   Execute JF_ShowTimeDiffToNow 'CLEAN BUFFER', @DateTimeStart

ende:

go
