LogStatus.sql

IF EXISTS(SELECT * FROM information_Schema.routines WHERE Specific_Name = 'LogStatus' )
	DROP PROCEDURE LogStatus 
GO
CREATE PROCEDURE dbo.LogStatus(@Msg AS VARCHAR(MAX)=NULL)
AS 
BEGIN
	DECLARE @CurrTime AS VARCHAR(100)
	SET @CurrTime = GETDATE() 

	set @msg = (select [Name] from sys.Filegroups where  is_default=1) 
		+ ': ' + @Msg			


	IF @msg IS NULL 
		RAISERROR ('(%s) ',0,1, @CurrTime ) WITH NOWAIT
	ELSE
		RAISERROR ('(%s) %s',0,1, @CurrTime, @Msg) WITH NOWAIT

	Insert Into CountyMessages(Message) values(@Msg)
END