Execute this on your database:
Code:
GO
/****** Object: StoredProcedure [dbo].[spStartUpLocatorStatus] Script Date: 11/17/2010 14:36:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spStartUpLocatorStatus]
@LocatorID int
, @IP varchar(15)
, @Port int
, @UpdateElapsedTime int
AS
SET NOCOUNT ON
IF EXISTS (SELECT LocatorID FROM LocatorStatus(NOLOCK)
WHERE LocatorID = @LocatorID) BEGIN
UPDATE LocatorStatus
SET IP = @IP, Port = @Port, UpdateElapsedTime = @UpdateElapsedTime,
LastUpdatedTime = GETDATE()
WHERE LocatorID = @LocatorID
END
ELSE BEGIN
INSERT INTO LocatorStatus(LocatorID, IP, Port, UpdateElapsedTime, LastUpdatedTime)
VALUES (@LocatorID, @IP, @Port, @UpdateElapsedTime, GETDATE())
END