Cacher is the code snippet organizer for pro developers

DECLARE @msg VARCHAR(100);

SET @msg = ' TIME: ' + CONVERT(varchar(8),GETDATE(),114) 
RAISERROR (@msg, 0, 1) WITH NOWAIT