lionofdezert

-- Table variable to hold intermediate data
DECLARE @ReportSQLErrorLogs TABLE
    (
      [log_date] [datetime] NULL,
      [processinfo] [varchar](255) NULL,
      [processtext] [text] NULL
    )

DECLARE @NumErrorLogs INT,
    @CurrentLogNum INT

lionofdezert

USE AdventureWorks

GO

--============== Supporting function dbo.udfGetFullQualName
IF OBJECT_ID('dbo.udfGetFullQualName') IS NOT NULL 
    DROP FUNCTION dbo.udfGetFullQualName
GO
CREATE FUNCTION dbo.udfGetFullQualName ( @ObjectId INTEGER )

lionofdezert

/*
 Script to send an alert through mail, with information that how many drive 
 space is required from next databases growth on a specific instance and how many
 space is available. 



 Script By: Amna Asif for ConnectSQL.blogspot.com
 */

lionofdezert

USE master
GO
-- Create table to hold valid IP values
CREATE TABLE ValidIPAddress (IP NVARCHAR(15)
CONSTRAINT PK_ValidAddress PRIMARY KEY)


-- Declare local machine as valid one
INSERT INTO ValidIPAddress
SELECT '<local machine>'