SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE dbo.InstantPrintTime
-- =============================================
-- Author:		Julian Kuiters
-- Site:		www.julian-kuiters.id.au
-- Create date: 3 July 2007
-- Description:	Print this current time and optionally a message without waiting for your current batch / transation to complete
-- Example:		EXEC dbo.InstantPrint 'Started Loop'
-- =============================================
(	
	-- from www.julian-kuiters.id.au
	@Message nvarchar(2000) = NULL
)
AS
BEGIN
	SET @Message = LEFT(CONVERT (CHAR (20), GETDATE (), 8) + COALESCE(@Message, 0), 2000);
	RAISERROR (@Message, 0, 1) WITH NOWAIT;
END
GO
GRANT EXECUTE ON dbo.InstantPrintTime TO PUBLIC
GO